hi,
See sample data below
What i am trying to achieve is Count of all AL's and P's For JanW2, where supervisor is Rob.
Answer i am looking for is 4.
I am trying to get the formula in one formula string.
Thanks for your help in advance.
Name Supervisor JanW1 JanW1 JanW1 JanW2 JanW2 JanW2
A Rob AL AL AL AL WO WO
B Rob P P P P P P
C Alisha AL SL P P WO WO
Bookmarks