Countif function criteria

[mrsushi]

Hi,

I have the sheet "daily Stats" which has dates in cell E1. E2, E3....etc. Each column has data of delivery times.

On another sheet called "monthly averages", i have a table with months in column A3:A13. B1 and B2 has a time range ie 00:00 and 00:59.

My current formula is in cell B3

COUNTIFS('Daily Stats'!$D:$XFD, ">="&B1, 'Daily Stats'!$D:$XFD, "<="&B2)

The formula is looking at ALL column data. However, I only want to count those within January, February etc?

Any ideas how to amend this formula please?

 

[Special-K99]

Why does it say "File not found" in your first screenshot?
Will you be fixing this or leaving the DIV/0 error as it is?

 

[mrsushi]

Why does it say "File not found" in your first screenshot?
Will you be fixing this or leaving the DIV/0 error as it is?

That will be left as it is.

Will this impact the count?

 

[Special-K99]

Possibly, I was gonna use a SUMPRODUCT() variant. Still working on this...

 

[Special-K99]

This is about as far as I can get

Can you base something on this test?
=SUMPRODUCT((E$2:G$4)*(A2=E$1:G$1))

I started of with A2=TEXT(MONTH(E1:G1),"mmmm") to match months but this didn't work.
A2:A4 reads January February March
E1:G1 reads January February March
with values in E2:G4

This will give you a total, you'll need to divide by number of entries in your column to get an average.

 

[mrsushi]

This is about as far as I can get

Can you base something on this test?
=SUMPRODUCT((E$2:G$4)*(A2=E$1:G$1))

I started of with A2=TEXT(MONTH(E1:G1),"mmmm") to match months but this didn't work.
A2:A4 reads January February March
E1:G1 reads January February March
with values in E2:G4

This will give you a total, you'll need to divide by number of entries in your column to get an average.

how can the current formula incorporate this? Apologies Im not sure how to tweak this