Calculating average over month

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?

Answers

  • Andrew Stills
    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

    He who fails to plan is planning to fail. - Winston Churchill

  • Andrew Stills
    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!

    Andrew

    He who fails to plan is planning to fail. - Winston Churchill

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!