Issue with AVERAGEIFS function

[EnergyGuy123]

I have weather data for a year that I am trying to average based on the hour. My averageifs function keeps giving me a #DIV/0! error and I can't figure out why. Any help is appreciated.

Equation: =AVERAGEIFS($C$2:$C$11085,$I$2:$I$11085,"="&R2,$K$2:$K$11085,"<="&S1,$K$2:$K$11085,">"&R1)

C2:C11085 - contains integer values that represent amount of degrees
I2:I11085 - contains date temperature was taken in MM/DD/YYYY format
R2 - The date I want the average for in MM/DD/YYYY
K2:K11085 - contains the time of day the temperature reading was taken in 24:00 format
S1 - hour of the day I want the temperatures averaged over in 24:00 format
R1 - previous hour in 24:00 format

 

[Nine Zero]

i think you dont need the quotes for the single equals sign

=AVERAGEIFS($C$2:$C$11085,$I$2:$I$11085,"="&R2,$K$2:$K$11085,"<="&S1,$K$2:$K$11085,">"&R1)

try this out

=AVERAGEIFS($C$2:$C$11085,$I$2:$I$11085,R2,$K$2:$K$11085,"<="&S1,$K$2:$K$11085,">"&R1)

 

[EnergyGuy123]

I actually was able to figure it out. the problem was that the column i thought i had updated to number format hadn't fully updated so it was still reading as text. If anyone has the same problem highlight the data and go to Data->Text to columns->Next->Deselect all delimiters->Next->Finish. Should fix the problem i had.