Sum IF

[Ed]

I need to so sum my columnn "I" (I2:I6828) based on values on certain values
in column F and Q. SUMIF wont do this. Is it SUMPRODUCT I need to use. Not
sure how to write the formula.

T.I.A.

 

[Norman Harker]

Hi Ed!

Here's a basic format sample:

=SUMPRODUCT(($A$10:$A$20=A1)*($B$10:$B$20="A")*($C$10:$C$20))

This will sum values in C10:C20 where corresponding entries in column
A are equal to the value in A1 *and* where corresponding entries in
column B are A.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.