Excel 2007 : Sumif checking two ranges

[Ron1121]

I'm trying to sum values in Col. C if certain criteria is met in cols A & B. My attached worksheet is an example of what I’m trying to do. Not sure if the Sumif is the best way to try and do this.

Any help would be greatly appreciated.

[sweep]

Hi,

Try Sumproduct

This will return the red and north option

=SUMPRODUCT((B1:B11="RED")*(C1:C11="NORTH")*(D1:D11))

change criteria and ranges as required.

[Ron1121]

Excellent…just what I wanted it to do….Thanks a lot