# Formula help - if cell contains a number, +1.

Solved/Closed
Crozzers Posts 2 Registration date Tuesday February 28, 2017 Status Member Last seen February 28, 2017 - Feb 28, 2017 at 06:05 AM
Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 - Feb 28, 2017 at 10:55 AM
Hi there,

Just a simple one for you guys!

I'm currently making a spreadsheet to tally up sickness days and occurrences. I currently enter how many sick days colleague have per week in cells D5, E5, F5 etc.

I need cell (B5) to increase by 1 if a following cell on the same row includes a number.

For example if D5 has a value of 3, E5 0, F5 1 and G5 2 then B5 would = 3. (3 True 1 False).

Does this make sense?

Danny

## 2 replies

Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 146
Feb 28, 2017 at 09:38 AM
Danny, Good morning.

Try to use:

B5 --> =COUNTIF(D5:G5, ">0")

Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Crozzers Posts 2 Registration date Tuesday February 28, 2017 Status Member Last seen February 28, 2017
Feb 28, 2017 at 10:46 AM
That is perfect! Thank you very much!

Kind regards,

Danny
Mazzaropi Posts 1978 Registration date Monday August 16, 2010 Status Contributor Last seen November 18, 2022 146
Feb 28, 2017 at 10:55 AM
Danny,

Thanks for the feedback.