Formula help - if cell contains a number, +1. [Solved/Closed]

Crozzers 2 Posts Tuesday February 28, 2017Registration date February 28, 2017 Last seen - Feb 28, 2017 at 06:05 AM - Latest reply: Mazzaropi 1826 Posts Monday August 16, 2010Registration dateContributorStatus April 15, 2018 Last seen
- 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
See more 

3 replies

Mazzaropi 1826 Posts Monday August 16, 2010Registration dateContributorStatus April 15, 2018 Last seen - Feb 28, 2017 at 09:38 AM
+1
Helpful
1
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
Was this answer helpful?  
Crozzers 2 Posts Tuesday February 28, 2017Registration date February 28, 2017 Last seen - Feb 28, 2017 at 10:46 AM
That is perfect! Thank you very much!

Kind regards,

Danny
Mazzaropi 1826 Posts Monday August 16, 2010Registration dateContributorStatus April 15, 2018 Last seen - Feb 28, 2017 at 10:55 AM
0
Helpful
Danny,

Thanks for the feedback.

Glad to have helped you.

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