I'm having trouble with the syntax to create a COUNTIFS Less than Variable WkStart, and Greater Than or Equal to Variable WkEnd for criterias 2 and 3.
I have defined the variables:
I have the syntax figured for a CountIFs with a variable:HTML Code:
And using the operators <>=:HTML Code:
But am having no success with mixing them together.HTML Code:
The result i'm looking for Should look something like: '=COUNTIFS(WorkingData!A:A,"LP",WorkingData!R:R,"*Attainment*",WorkingData!J:J,"<11/8/2019",WorkingData!J:J,">=11/4/2019")
Bookmarks