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

Report
Posts
2
Registration date
Tuesday February 28, 2017
Status
Member
Last seen
February 28, 2017
-
Posts
1918
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 4, 2021
-
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

Posts
1918
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 4, 2021
143
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
2
Registration date
Tuesday February 28, 2017
Status
Member
Last seen
February 28, 2017

That is perfect! Thank you very much!

Kind regards,

Danny
Posts
1918
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 4, 2021
143
Danny,

Thanks for the feedback.

Glad to have helped you.

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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!