MrExcel Publishing
Your One Stop for Excel Tips & Solutions

SUMPRODUCT using arrays?


Posted by tracy28 on January 31, 2002 7:52 AM

I know how to use arrays (CTRL Shift Enter) for formulas such as SUM, MAX, AVERAGE but I can't seem to get it to work for a SUMPRODUCT. Can anyone help?

I want to sumproduct 2 ranges (columns B and C) but only if the values in column A are equal to a particular value.

Thanks in advance!
Tracy


Posted by Albert on January 31, 2002 8:21 AM

Example:
=SuMPRODUCT((A1:A10="a")*(B1:B10=4)*(C1:C10>2))
Albert


Posted by tracy28 on January 31, 2002 8:32 AM

THANKS A BUNCH! This worked great!