I am trying to create a formula to track how many calls we run on holidays. I am trying to make a formula like this, =COUNTIFS(G2:G999,Holidays, B2:B999, "U8"). Basically, G2:G999 is a column full of dates for calls that we have run. Holidays is the named range I have made for all of the holidays dates throughout the year, this named range exists on a seperate tab if that matters. B2:B999 is a column of the types of calls that we ran, ex: structural, medical, hazmat, etc. U8 is a cell containing the word Structural. I want this formula to calculate how many structural calls were ran on holidays. Any help would be greatly appreciated.
