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 ...
Detlef_Lewin
Dec 13, 2018Silver Contributor
Hi
=SUMPRODUCT(COUNTIFS(G2:G999,Holidays,B2:B999,U8))
- Derby0207Dec 13, 2018Copper ContributorWorked like a charm thanks!