Conditional Sum

[Joe]

=SUM(IF($V$3:$V$72=F$5,IF($W$3:$W$72=$C24,$X$3:$X$72,0),0))

I am trying to get a list of data into table format.

if the data in any of the 'V' column agrees to the label at the top and if
the data in any of the 'W' column agrees to the label at the side, then add
up the relevant cells to put it in the table.

I would like to do this with a formula as the data is likely to change on a
monthly basis and I will only need to update the list.

I have put together the above formula but it comes back to '0'.

Can anybody shed any light, it would be very much appreciated.

Thanks

 

[Frank Kabel]

Hi
have you entere the formula as array formula with CTRL+SHIFT+ENTER.
For an alternative see:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html