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?

Find more posts tagged with

Accepted answers

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.