SumProduct If question

[dwg83]

I am using this equation:
=SUMPRODUCT((($AH$100:$AI$100<>"")*($AH$101:$AI$101)*($AH$100:$AI$100)))

only problem is, is if one of the cells I am testing has a formula that returns "", the value of the cell with the original equation is #VALUE!

Is there a way around this?

Thanks,
David

 

[Robert Mika]

Not sure what are you trying to accomplish multiplaying the same cells but try this

=SUMPRODUCT(((len($AH$100:$AI$100)<>"")*($AH$101:$AI$101)*($AH$100:$AI$100)))

 

[Aladin Akyurek]

I am using this equation:
=SUMPRODUCT((($AH$100:$AI$100<>"")*($AH$101:$AI$101)*($AH$100:$AI$100)))

only problem is, is if one of the cells I am testing has a formula that returns "", the value of the cell with the original equation is #VALUE!

Is there a way around this?

Thanks,
David

Try...

=SUMPRODUCT($AH$100:$AI$100,$AH$101:$AI$101)

Does this help?