check empty cells in a range

[Rodrigues]

Hi there
I'm trying o use a formula on file attached (cell AH6), to check if cells in a range are empty or not and the result I'm getting is zero, if cells are empty should show "".
Can someone help me?
Thanks in advance
Regards
R

 

[Rodrigues]

File attached.

 

[NARAYANK991]

Hi ,

The correct formula would be :

=IF(AND(AE6:AG6 = ""), "", SUM(AE6:AG6))

entered as an array formula , using CTRL SHIFT ENTER.

AE6 through AG6 will either be blank or contain a number ; now in a comparison , a cell which is blank or contains the null string "" is not equal to 0.

Narayan

 

[John Jairo V]

Hi!

Another option could be (non-cse):
=IF(COUNT(AE6:AG6),SUM(AE6:AG6),"")

Blessings!

 

[Rodrigues]

Thank you Narayank and John, much appreciated.
Regards and Blessings
R