# Calculating average over month

Options
✭✭

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?

• ✭✭✭✭✭
Options

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

• ✭✭✭✭✭
Options

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!