MS Excel help please... =) - GoFuckYourself.com

szango420 · 08-07-2006, 11:04 PM

Im making a balance sheet for expenses. ive attached it so you can see what im trying to accomplish. I have droplists under my expense column. the drop down list draws from the F column. i want the G column to sum the individual catagories from the entire D column but only that catagory. i hope that makes sense.. i have no idea how to accomplish this. any help would be great.. thank you!

http://www.szango.com/expenses.zip

Juicy D. Links · 08-07-2006, 11:18 PM

Double L · 08-07-2006, 11:21 PM

Wont your drop down be pulling all the info to the D column and so its simply:

Code:

=SUM(D2:D10)

??

dRI-X · 08-07-2006, 11:24 PM

just see the formulas

szango420 · 08-07-2006, 11:28 PM

Quote:

Originally Posted by Double L

Wont your drop down be pulling all the info to the D column and so its simply:

Code:

=SUM(D2:D10)

??

well.. i have an autofilter that will display only one catagory at a time, but the normal view lists all of the catagories. there has to be some sort of exception... but i cant seem to find it... for instance, if colum C is ADVERTISING, then all of the advertising costs listed in column D would need to be added.. but if i did D2:D10, it would add all catagories..

xLaborJames · 08-07-2006, 11:32 PM

Quote:

Originally Posted by Juicy D. Links

Get much sleep lately jooicey? Cucumbers will help maintain your thexiness.

Double L · 08-07-2006, 11:47 PM

Ah.. I thought from looking at it when you entered a cost and chose the category it would just total it over to column D and then just sum for your totals... I see now when I choose "All" your F and then sums and entering some more I see your "totals" problem. Shit Im lost.. A sumif function maybe? Im out of the Excel loop

szango420 · 08-07-2006, 11:52 PM

me too.. =( i thought maybe sumif too.. but had no luck trying to figure it out... maybe someone else knows...

AsianDivaGirlsWebDude · 08-08-2006, 12:09 AM

I'm not looking at your spreadsheet, since I don't download/open Zip/executable files, however if I understand you correctly, it would appear that you simply need to run the sum wizard = for column D.

Then, if you want everything in the D column to display in column G for further calculations, you would put in that cell, = value in column D cell, which has the total you are looking for.

If you do a screenshot, I can answer this for you (I used to teach Excel).

ADG Webmaster

BigBen · 08-08-2006, 02:08 AM

It's not answering your question, but try checking out Quickbooks.

joshll · 08-08-2006, 02:12 AM

Scotty.T · 08-08-2006, 02:31 AM

Try this, if I understand you correctly this will do it, just expand the ranges and change the criteria word

=SUM(SUMIF(C$2:C$37,"Advertising",D$2:D$37))

The smiley in the last bit is a colon and D obviously

kapai · 08-08-2006, 02:35 AM

Quote:

Originally Posted by szango420

Im making a balance sheet for expenses. ive attached it so you can see what im trying to accomplish. I have droplists under my expense column. the drop down list draws from the F column. i want the G column to sum the individual catagories from the entire D column but only that catagory. i hope that makes sense.. i have no idea how to accomplish this. any help would be great.. thank you!

http://www.szango.com/expenses.zip

The way you want to do this is awkward as I presume your C column will be your categories and the D column is the figure?

You need to use formulas to do this automatically however if you keep adding info to the C column the formula wil not work. I will set up a worksheet of how I think you want it to work and send it to you. I am MOUS certified

BlueDesignStudios · 08-08-2006, 02:36 AM

use the paperclip

the paperclip knows everything

kapai · 08-08-2006, 02:50 AM

You need to put those categories into columns and total the cloumns with a formula such as the following

=SUBTOTAL(9,A2:A18)

RayBonga · 08-08-2006, 03:40 AM

Here you go ("save target as"):

http://naoestafacil.no.sapo.pt/temp/...20expenses.xls

I think I understood what you needed, let me know if it works.

08-07-2006, 11:04 PM	#1
szango420 Confirmed User Join Date: Feb 2006 Location: Colorado Posts: 244	MS Excel help please... =) Im making a balance sheet for expenses. ive attached it so you can see what im trying to accomplish. I have droplists under my expense column. the drop down list draws from the F column. i want the G column to sum the individual catagories from the entire D column but only that catagory. i hope that makes sense.. i have no idea how to accomplish this. any help would be great.. thank you! http://www.szango.com/expenses.zip

08-07-2006, 11:21 PM	#3
Double L Confirmed User Join Date: Nov 2004 Location: US Posts: 349	Wont your drop down be pulling all the info to the D column and so its simply: Code: =SUM(D2:D10) ??

08-07-2006, 11:24 PM	#4
dRI-X Confirmed User Join Date: Feb 2006 Location: In A Free Country Posts: 372	just see the formulas __________________ ICQ:327383017

08-08-2006, 12:09 AM	#9
AsianDivaGirlsWebDude Purveyor, Fine Asian Porn Industry Role: Join Date: Jul 2004 Location: San Francisco Bay Area Posts: 38,323	I'm not looking at your spreadsheet, since I don't download/open Zip/executable files, however if I understand you correctly, it would appear that you simply need to run the sum wizard = for column D. Then, if you want everything in the D column to display in column G for further calculations, you would put in that cell, = value in column D cell, which has the total you are looking for. If you do a screenshot, I can answer this for you (I used to teach Excel). ADG Webmaster __________________ Asian Diva Girls - Exclusive Photos and Videos Asian Diva Girls Affiliate Program (50% ccBill Revshare)

08-08-2006, 02:12 AM	#11
joshll Confirmed User Industry Role: Join Date: Jul 2006 Location: Tenerife, Los Gigantos Posts: 1,534	__________________ WiredBall PinPointsX ICQ: 227454293

08-07-2006, 11:18 PM	#2
Juicy D. Links So Fucking Banned Industry Role: Join Date: Apr 2001 Location: N.Y. -Long Island -- Posts: 122,992

08-07-2006, 11:47 PM	#7
Double L Confirmed User Join Date: Nov 2004 Location: US Posts: 349	Ah.. I thought from looking at it when you entered a cost and chose the category it would just total it over to column D and then just sum for your totals... I see now when I choose "All" your F and then sums and entering some more I see your "totals" problem. Shit Im lost.. A sumif function maybe? Im out of the Excel loop

08-07-2006, 11:52 PM	#8
szango420 Confirmed User Join Date: Feb 2006 Location: Colorado Posts: 244	me too.. =( i thought maybe sumif too.. but had no luck trying to figure it out... maybe someone else knows...

08-08-2006, 02:08 AM	#10
BigBen Confirmed User Join Date: Nov 2004 Location: scv Posts: 2,299	It's not answering your question, but try checking out Quickbooks.

08-08-2006, 02:31 AM	#12
Scotty.T Confirmed User Join Date: Nov 2004 Location: Scotland Posts: 1,062	Try this, if I understand you correctly this will do it, just expand the ranges and change the criteria word =SUM(SUMIF(C$2:C$37,"Advertising",D$2:D$37)) The smiley in the last bit is a colon and D obviously __________________ . Last edited by Scotty.T; 08-08-2006 at 02:33 AM..

08-08-2006, 02:36 AM	#14
BlueDesignStudios Confirmed User Industry Role: Join Date: Feb 2003 Location: Australia Posts: 9,492	use the paperclip the paperclip knows everything __________________ Blue Design Studios - Adult Design Specialists! Email me for a free quote: [email protected]

08-08-2006, 02:50 AM	#15
kapai Confirmed User Join Date: Jan 2006 Posts: 245	You need to put those categories into columns and total the cloumns with a formula such as the following =SUBTOTAL(9,A2:A18)

08-08-2006, 03:40 AM	#16
RayBonga too cool for highschool Join Date: Nov 2005 Location: East side, West side, Worldwide! Posts: 12,164	Here you go ("save target as"): http://naoestafacil.no.sapo.pt/temp/...20expenses.xls I think I understood what you needed, let me know if it works. Last edited by RayBonga; 08-08-2006 at 03:42 AM..