If blank cell value of 1 + add 9 cells together

Closed
Report
-
Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
-
Hello,
I need a formula where if the cell is blank it gets a value of 1, then I need it to add 9 cells together (in the same row). If something (text) is in the cell that number is not added.





1 reply

Posts
1947
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
November 11, 2021
147
teej, Good afternoon.

Not clear your doubt, but.....
Try to use:

A1 -->
=IF(ISTEXT(A2),"",IF(A2="",SOMA(1,A10:A18),"")

Is that what you're looking for?
I hope it helps.