Sum of Cells from Vlookup

[ngay528]

I am making a personal expenses sheet to calculate my monthly expenses. i have each expense on my CC marked according to a validation list I have (for example Gas, Grocery, Shopping, etc)

How do i combine the Sum and Vlookup formulas to return the total amount spent on Gas for instance. This will be used for each of my type of expenses.

if its not possible, I can probably just write a macro

Thanks

[daddylonglegs]

You can probably use SUMIF function, e.g. if expense type is in column A and amounts in column B try

=SUMIF(A:A,"Gas",B:B)

[JBeaucaire]

A SUMIF() formula would work. Or a SUMPRODUCT() if you also wanted to see it categorized by months, too.

Here's a sample sheet showing the fancier layout.

[navwelch]

JBeaucaire

hi as sent a message please look at the excel file and tell me why i am getting an error...

thx

[modytrane]

here's your file with formula fixed.
modytrane

[JBeaucaire]

Have a look here, reformatted the summary section a little.

[navwelch]

thanks a lot for both of you.... me learning a lot...

regards,

naveen