|
Post by disneypal on Nov 9, 2021 20:13:45 GMT
I hope someone can assist. I am sure this is a simple formula but for some reason I cannot figure it out I will have a list like the sample below that will have 30+ employees. I need to have the count at the bottom show the number of employees that are marked "Office" - for example on 11/15/2021, the count should be "1" since only 1 employee is in the office that day.
What formula would I use to get that?
Thanks for your help.
|
|
|
Post by marzbar71 on Nov 9, 2021 20:33:17 GMT
Try: =COUNTIF(A1:A5,"Office")
Where A1:A5 is the range of cells your data is in.
|
|
|
Post by disneypal on Nov 9, 2021 20:35:07 GMT
marzbar71 - Thank you so much!! That did it!!
|
|
|
Post by mayceesgranny on Nov 9, 2021 21:12:03 GMT
FYI - When I get stuck I Google the issue and generally find an excel solution.
|
|
|
Post by disneypal on Nov 9, 2021 22:33:38 GMT
FYI - When I get stuck I Google the issue and generally find an excel solution. Thanks - I tried that first since Google usually does provide and answer, but for some reason I couldn't find the solution this time
|
|