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.![]()
Bookmarks