Adding values based on value of adjacent cell...

[Finalfrontier1976]

Hi,

I have attached my sheet to this question to help explain what I am trying to do.

In this spreadsheet I have to keep a track of some figures based on a depot I send items to.

What I want to do is have a formula so that if the values in Column H is equal to G then add up all the adjacent values in Column F that relate to value G. The same if a cell contains M then add up all the adjacent values in Column F.

Thanks,
Lewis

[XOR LX]

Hi,

If you change your entries in cells A22:A25 to simply G, P, S and M (i.e. remove the "Total " part) then this formula in B22 and copied down will give you your desired results:

=SUMIF($H$5:$H$18,A22,$F$5:$F$18)

Regards