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

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

just see the formulas

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..

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

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 :(

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

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

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

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

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

use the paperclip

the paperclip knows everything

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

=SUBTOTAL(9,A2:A18)

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.