Hello,
I'm using the COUNTIFS formula but am having trouble getting the count to flow. Here is what I have currently:
=COUNTIFS(B:B,"ground",C:C,"6/28/2014",D:D,GROUNDSTAFF)
Where:
- Column B contains different levels. I only need to count those that are on the "ground" level
- Column C has different expiration dates. I only need to count those that expire on 6/28/2014
- Column D Contains the initials of a few different staff. I need to count several different staff (JB, MJ, and JG)
I created a custom named range named GROUNDSTAFF that points to cells which have the specific initials I want to count, but my count always returns zero.
I.e. - I want to count all the ground levels that expire 6/28/2014 from only the staff JB, MJ, and JG. Is there a way around my issue while still using 1 formula?
Thank you,
Greemo
I'm using the COUNTIFS formula but am having trouble getting the count to flow. Here is what I have currently:
=COUNTIFS(B:B,"ground",C:C,"6/28/2014",D:D,GROUNDSTAFF)
Where:
- Column B contains different levels. I only need to count those that are on the "ground" level
- Column C has different expiration dates. I only need to count those that expire on 6/28/2014
- Column D Contains the initials of a few different staff. I need to count several different staff (JB, MJ, and JG)
I created a custom named range named GROUNDSTAFF that points to cells which have the specific initials I want to count, but my count always returns zero.
I.e. - I want to count all the ground levels that expire 6/28/2014 from only the staff JB, MJ, and JG. Is there a way around my issue while still using 1 formula?
Thank you,
Greemo