Double SUMIF

[garethgtt]

Hi,


I currently have 2 SUMIF statments however i now need to in the same formula do the 2 SUMIFs and subtract the result of one from the other..all in the same formula.

is this possible?

My 2 formulas are as follows:

=SUMIF($F$36:$F$55,AM60,$C$36:$C$55)

=SUMIF($H$36:$H$55,AM60,$G$36:$G$55) I need to subtract the result of this one off the top one

Thanks

[Carim]

Hi,

What about ...

Please Login or Register  to view this content.