Forum Discussion
Derby0207
Dec 13, 2018Copper Contributor
Excel formula help
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.
2 Replies
- Detlef_LewinSilver Contributor
Hi
=SUMPRODUCT(COUNTIFS(G2:G999,Holidays,B2:B999,U8))
- Derby0207Copper ContributorWorked like a charm thanks!