S
Steve H
Hello
I am trying to use a sumproduct formula to evaluate the following:
if Range1=Criteria1 or =Criteria2
and Range2=Criteria3 or =Criteria4
and Range3=Criteria5
and Range4=Criteria6
return the value in SumRange
so my formula would look like this?
sumproduct((Range1=Criteria1)+(Range1=Criteria2)*(Range2=Criteria3)+
(Range2=Criteria4)
*(Range3=Criteria5)*(Range4=Criteria6 )* SumRange)
Thanks!
I am trying to use a sumproduct formula to evaluate the following:
if Range1=Criteria1 or =Criteria2
and Range2=Criteria3 or =Criteria4
and Range3=Criteria5
and Range4=Criteria6
return the value in SumRange
so my formula would look like this?
sumproduct((Range1=Criteria1)+(Range1=Criteria2)*(Range2=Criteria3)+
(Range2=Criteria4)
*(Range3=Criteria5)*(Range4=Criteria6 )* SumRange)
Thanks!