Hi, please have a look at the attached picture. Column A is a code for different times of the day (each code representing a different time). Columns E and F translate each code as being either AM or PM. Column B is a list of names.
What i would like to do is count the number of instances where Neil has an AM code next to his name, a PM code next to his name and the same for Swift.
This is a simplified version of my problem which contains countless codes and multiple name.
I need the final formula to basically say:
"Count the number of instances for Neil where he has a code which represents the AM" (and PM and dito for Swift).
For example, =SUMPRODUCT(--(A:A="2b"),--(B:B="Neil")) returns all of those which have a code of 2b, but i want to also return everything else which is PM - WITHOUT simply adding 2b + 1k + r4. Ie I want it to determine at runtime which are the PM ones.
I hope this makes sense! Please help! Any suggestions!!
Thanks!
Bookmarks