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?

Many thanks in advance.

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
1
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
0
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.

Glad to have helped you.

Have a nice day!
--
Belo Horizonte, Brasil.
Marcílio Lobão
0