show blank result when there is nothing

  • Thread starter Thread starter jv
  • Start date Start date
J

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
 
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
 
Back
Top