Report

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

Ask a question Crozzers 2Posts Tuesday February 28, 2017Registration date February 28, 2017 Last seen - Last answered on Feb 28, 2017 at 10:55 AM by Mazzaropi
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 
Helpful
+1
plus moins
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 2Posts 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
Reply
Leave a comment
Helpful
+0
plus moins
Danny,

Thanks for the feedback.

Glad to have helped you.

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

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!