Sumproduct in Excel 2003
=SUMPRODUCT(IF(A2:A4="Jim",B2:B4,0),(C2:C4))
this is an array formula, pl press CTRL+SHIFT+ENTER simulatneously.
Vijay
"lisay" wrote:
Help please!
I have the following data:
A B C
Jim 10 50%
Jack 10 100%
Jim 5 100%
If I'm looking for the sumproduct of col B and C, if col A = Jim. I don't
know how to do this in Excel 2003. I can do this in Excel 2007.
Any help would be much appreciated.
|