"Count IF" statement

[enoch]

I'm an excel noob but i was wondering if someone could help me with a if command. I am trying to make a cell showing participants from a range (H5:H26) if it is = to or > then 1 and then i need the formula to add one if the value is true. but showing a total of participants. Please help

In case the above didn't make any sense. I have a spread sheet with names and hours and total of hours. what i need is for a cell to display the number of participants if one or more hours are showing in the total of hours range. i don't want it to total the hours or anything like that.

[NBVC]

Try Countif

e.g. =Countif(A1:A100,">1")

where A1:A100 contains total hours for each participant... adjust range as necessary

[enoch]

Thank you so much. i had to modify the 1 to 0 because your formula was saying anything >1 and i needed anything >=1...actually will that work. can i put >=1?

[NBVC]

Yes you can use ">=1" or just ">0" if using whole numbers...