Hi all,
I'm attempting to write a formula to tell me the total number of subjects I'll be working with on a given day. For example, if 28-May (W2) appears in the array F31:M48, I need W4 to return the sum of the number of subjects (B31:B48) from all of the studies where it appears (4 total). I know that number should be 36 based on manually looking at the array and adding the numbers, but I would like to have this number returned automatically.
Currently, I'm using the "CountIf" function to tell me how many studies I'm working on that day but would like to know the total number of subjects.
Any advice?
Cheers,
Matt
Capture.PNG
Bookmarks