Try
=SUMPRODUCT(--(A2:A500="x"),--(B2:B500="y"),C2:C500)
Regards,
Peo Sjoblom
"Holly B." wrote:
I would like to sum a range if column A = x and column B = y then sum those
numbers in range C that meet the criteria. Is this possible? SumIf only
allows for one range and criteria, how can I get around this?
|