Dates in AVERAGEIF Formula

Hello all!

I need to use formula averageif to count average of duration of projects in weeks, it is bases on the end date of it. I try to do it in Summary of the sheet. Here is the formula but id doesn't work.

=AVERAGEIF([End Date:End Date], [End Date]@row<DATE(2019,12,31), Weeks:Weeks)

It shows that this formula is an invalid operation

Thank you

Find more posts tagged with

Accepted answers

All comments

Heather Duff

Hi @ViktoriiaKocherha

I'm not sure if this will fix your formula completely, but try putting square brackets around each instance of "End Date" - so the formula would read: (I marked the missing brackets in bold)

=AVERAGEIF([End Date]:[End Date], [End Date]@row<DATE(2019,12,31), Weeks:Weeks)

ViktoriiaKocherha

https://community.smartsheet.com/discussion/comment/307344#Comment_307344

Hey, I've tried that, still not working :/ It writes unpareseable.

But thank 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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.