What is wrong with this =AVERAGEIF formula

Here is my formula - =AVERAGEIF({Week Number}, ={Current Week}, {Daily Cnt Comp})

Where Week number is a cross reference to Audit Report column Week number

Current week is a cross reference to the Audit Report SS to the current week number based off the current date

I cross reference the {Daily Cnt Comp} column in the Audit Report sheet and If any entry that contains the same week number as current week number then I want to average the daily count of completed

With the above formula it returns 0 even though I have 4 rows that should meet the criteria

Find more posts tagged with

Formulas

Accepted answers

All comments

David Tutwiler

I think the problem is the = beside Current Week. If you just make it:

=AVERAGEIF({Week Number}, {Current Week}, {Daily Cnt Comp})

it should work.

bday2329

Thank you for a quick reply

I changed as recommended

=AVERAGEIF({Week Number}, {Current Week}, {Daily Cnt Comp})

It still returns 0

L_123

What happens if you replace {current week} with 37?

Paul Newcome

I was thinking along the same lines as @L@123. You cannot compare two cells side by side on a row basis by using two separate ranges like that. You would need to find a way to replace that second range with 37 or a reference to a cell that contains 37, or you would need to insert a helper column on the source sheet that would make the comparison and flag each appropriate row then use that in your AVERAGEIF.

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.