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



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!