show blank result when there is nothing

[jv]

Good day,

Kindly correct my formula, i need to show a blank result
if there is nothing in column E15:E35.

=SUMIF(BFS3!$C$15:$C$35,'-'!B3,BFS3!$E$15:$E$35)

Thanks and regards.


jv

 

[Stefan Hägglund [MSFT]]

Hi!

You could use a formula like:
=IF(SUMIF(BFS3!$C$15:$C$35,'-'!B3,BFS3!$E$15:$E$35)=0,"",SUMIF(BFS3!$C$15:$C
$35,'-'!B3,BFS3!$E$15:$E$35))
You cannot use this cell as a reference in other formulas, since it returns
the text "".

Stefan Hägglund
Microsoft

 

[jv]

Stefan,

I tried your formula and it works perfectly well!

Thanks and regards.


jv