Forum Discussion

Onetruth's avatar
Onetruth
Copper Contributor
Nov 29, 2022

Please Help:)

Im trying to create a workforce spreadsheet and I was wondering if someone could possibly help me.... I'm having a difficult time trying to write out what's needed, so I added a picture. I hope this ...
excel
Formulas and Functions
HansVogelaar's avatar
HansVogelaar
MVP
Nov 29, 2022

Onetruth 

Perhaps

 

=COUNTIF(range, ">0")

 

or even

 

=COUNT(range)

  • Onetruth's avatar
    Onetruth
    Copper Contributor
    Dec 05, 2022
    Hello....

    Thank you for you time..... the =COUNTIF(range, ">0") and =COUNT(range) didn't work for me....
    I did get it to work using..... =IF(HP7+HP8>=1,1)+IF(HP9+HP10>=1,1)

Resources