SUM IF - Multiple Rows

Hi,

I have the following SUMIF:

Please Login or Register  to view this content.

But Rather than SUM Range "AE" I need it to sum multiple coulms (O,P,Y,Z) is this possible?

Paul

...not with SUMIF unless you just string together 4 SUMIFS, one for each column to sum.....try SUMPRODUCT but it's best to restrict the ranges, e.g. something like

=SUMPRODUCT(('Sales by Customer'!E2:E100=B510)*(('Sales by Customer'!O2:P100)+('Sales by Customer'!Y2:Z100)))