Calculating average over month

SMChou

Hello,

I am trying to calculate average of days spent per assessment over a month, but my formula is returning a zero even though the data does not support this.

Here is the formula I am using:

=AVERAGEIF({Temperature Assessment Site Days}, AND(@cell >= DATE(2022, 1, 1), @cell <= DATE(2022, 1, 31)), {Temperature Assessment Site Days})

What did I miss?

Andrew Stills

Are you able to send a screen shot? (Of course remove any private or identifying information).

From a quick read it looks like your only working with one row and column.

Andrew Stills

I was able to produce this formula to correctly calculate what you were trying to do:

=AVERAGEIF(Date:Date, AND(@cell >= DATE(2022, 1, 1), @cell <= DATE(2022, 1, 31)), [Temperature Assessment Site Days]:[Temperature Assessment Site Days])

I set this up in a single sheet so you'll need to rework it to fit your cross-sheet referencing.

Hope this helps you!