SUM of various expenses per month

[karambos]

NOTE TO ADMIN: I originally posted this in the "Classic Visual Basic" Forum and was advised to include it here. I tried to delete it but wasn't allowed. I have nothing against you deleting it where appropriate. Thankyou.

I have a worksheet where column A is the date (in format 01-Jan-2004), column C is the amount spent and column D is what is was spent on.

I would like to find out how much was spent on food each month, how much on travel etc. So I need to be able to say

Where column A = November 2004 AND column D = "Food" SUM all numbers in column C

But I'm a novice at Excel. Would this best be done by writing a function in visual basic or is there a quicker way to do it?

Thanks for any help

[Ecniv]

'sumif' I think will be the function you want.

You could do a pivot to get all the distinct (unique) types then sumif to get totals.

[RobDog888]

Yes, SUMIF is the correct function for this. I have made a small ex. for you in case you havent solved it yet.
1-Jan-04 25 Food
1-Jan-04 50 Food
1-Jan-04 25 Stuff
1-Jan-04 100 Food
1-Jan-04 75 Stuff
1-Feb-04 150 Food
1-Feb-04 200 Stuff
1-Feb-04 25 Food
1-Feb-04 50 Stuff
1-Mar-04 100 Food
1-Mar-04 275 Stuff
1-Mar-04 25 Food
1-Mar-04 25 Food
--------------------------------
500

=SUMIF(D1:D13,"Food",C1:C13)