Previous Topic Next Topic

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 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - 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
Related:

2 responses

Answer 1 / 2
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
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
Answer 2 / 2
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
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

Similar discussions

Counting cells containing only numbers
jutulu -
jutulu -

4 responses
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Excel - IF function with multiple words
Nick -
user -

14 responses