If blank cell value of 1 + add 9 cells together

Closed
Teej - Oct 1, 2015 at 11:58 AM
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
- 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.





1 reply

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
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