Help with formula for conditional summing of cells

Hi there,

I'm trying to do a spreadsheet for our charity accounts. We have 8 categories that we want to collect totals for so I need something like

=sum (f2...f25 where the value in the corresponding category on the row = "Forum" )

Can't quite get my head round how to do it - I've attached the spreadsheet so you can see what I'm on about - the RED cell is the one I want to put the conditional total in (once I get a formula I can edit it for the rest of the doc)

Many thanks

Gail

I've attached

Put this formula in cell I7:

=SUMIF(D$4:D$25,H7,F$4:F$25)

then copy down.

Hope this helps.

Pete

Flippin marvellous - thank you so much

Gail