If blank cell value of 1 + add 9 cells together

Closed
Teej - Oct 1, 2015 at 11:58 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Oct 2, 2015 at 01:12 PM
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.





Related:

1 response

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Oct 2, 2015 at 01:12 PM
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.
0