Formula referencing multiple criteria
I am a little stumped on where to start with this one. I have where I want this sheet to count each of the columns of another sheet if certain criteria are met. For instance, I want to know the sum of Beginning Case Load - Active Status if the role is nursing and the date helper column is 2/2/24 (the return response should be 10).
Formulas are not a strong point for me, I am trying to learn.
I want this to calculate on a separate sheet.
Here is the destination sheet
Here is the source sheet
Help Article Resources
Check out the Formula Handbook template!