How can I specify 2 different ranges and 2 different criteria in a sumif formula? Thanks in advance!
S Steve Sep 24, 2003 #1 How can I specify 2 different ranges and 2 different criteria in a sumif formula? Thanks in advance!
A Alan Sep 24, 2003 #2 You cant with SUMIF but you can with SUMPRODUCT =SUMPRODUCT((range1 = value1)*(range2 = value2)) HTH Alan
You cant with SUMIF but you can with SUMPRODUCT =SUMPRODUCT((range1 = value1)*(range2 = value2)) HTH Alan
D Don Guillett Sep 24, 2003 #3 What is being summed? =SUMPRODUCT((range1 = value1)*(range2 = value2)) Click to expand... may need to add a range to be summed =SUMPRODUCT((range1 = value1)*(range2 = value2)*range3)
What is being summed? =SUMPRODUCT((range1 = value1)*(range2 = value2)) Click to expand... may need to add a range to be summed =SUMPRODUCT((range1 = value1)*(range2 = value2)*range3)
