Hi All
In the attached excel I just wanted to add Date wise calculation.
In the table called “Weekly AVG” I have already set the formula which I want, Now I want to add the Date in the formula.
Whatever the date I will put in the "Start date" and "End date" in the excel and the data should be reflecting for that same period of time only.

I have tried the below formula in “U7”
=SUMPRODUCT((C:C=T7)*(D:D="<>")*(DATE>=$V$2)*(DATE<=$AE$2))

The above formula is not working this is not working.
But in “U8” I have putted
=IFERROR(COUNTIFS(C:C,T8,D:D,"<>"),"") ----- this is working without any date,

If anyone can help me to get the data it will be a great help.

Regards
Arindam

Attached File : - Countif formula.xlsx