# 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

Tags:

• 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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!