Hot to SUM this.

[firstWeMeet]

[/url][/IMG]

Hi, just want to know what formula for D13 that calculate the value of A2 to A10 base from D2 to D10 which has a no value. D2 to D10 has a formula of =IF(B2="","",A2*C2).
from the example above, the value of D13 should be 40.5 which is A5 and A7 since the D5 and D7 is no value. thanks

 

[Sal Paradise]

=sumif(d2:d10,"",a2:a10)

 

[CWatts]

You may have to elaborate a bit more on what you mean by "calculate the value" as there are tons of ways to do that.

I'll take my best guess and assume this is what you're looking for:

=SUMIF(D2:D10,"",A2:A10)

Please provide more detail if it's not.