Sumif

Hi,

Please would you mind advising on the correct formula for the attached please? I just want to bring back the total of 2 cols based on a department criteria. I can't get my sum if to work...

Many thanks

Suzanne

You can put this formula in cell E27:

=SUMIF($B$2:$B$22,B27,$C$2:$C$22)+SUMIF($B$2:$B$22,B27,$D$2:$D$22)

then copy down.

An alternative is to use this array* formula:

=SUM(IF($B$2:$B$22=B27,$C$2:$C$22+$D$2:$D$22))

and copy that down.

*Note that an array formula needs to be committed using the key combination of Ctrl-Shift-Enter (CSE) instead of the usual < Enter >.

Hope this helps.

Pete

Thanks Marvin - that's great.

Thank you Pete - that's great. I'll definitely be making use of the array formula in the future!

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.