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
Answers
-
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.
-
Thank you for a quick reply
I changed as recommended
=AVERAGEIF({Week Number}, {Current Week}, {Daily Cnt Comp})
It still returns 0
-
What happens if you replace {current week} with 37?
-
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.
Help Article Resources
Categories
Check out the Formula Handbook template!