What formula will give me a count of how many cells in a list meet certain criteria? I need a summary of how many times each name has an entry for "days off". For example:
Days Off
John 1 **This is where I need the formula**
Chris 1 **For example, in row 1 the answer would be 3
Jason 2 **Answer in row 2 would be 5
John 2
Chris 4
Thanks so much!
Days Off
John 1 **This is where I need the formula**
Chris 1 **For example, in row 1 the answer would be 3
Jason 2 **Answer in row 2 would be 5
John 2
Chris 4
Thanks so much!