Thread: Sum if / product - can get it to work?

Hi,

I have been trying for ages to get a formula to work which will sum a column of entries based on two categories. I am not too keen on using a pivot table and would like to find out what the best formula to use is.

basically I have 3 columns of data with about 2000 row entries in each column.
Column A) consists of various dates across through the year
Column B) consists of a variety of categroies of spend
Column C) is the amount in £

I would like to create a formula that sums the total amuont of £ spent on catergory "income" for example for the month of January.

so far I have tried

{=SUM(IF($B$51:$B$684 = "Income", IF($A$51:$A$684 = DATEVALUE("January 2011"), $A$51:$A$684, 0), 0))}

but i cant get it to work. I would like to repeat this for each month and so on.

Your help will be very much appreciated.

Al

Thanks but all I seem to get is the answer 0.00 so there is something not quite right somewhere??

Take that back - got it to work. Thanks v much

Wondering if you can help once more -

how would i create a formula that takes only partial cell contents from the category say "Car" to capture all sub-catergories of that category??

Thanks in advance