AVERAGEIF when referencing another sheet

blmccue
blmccue ✭✭
edited 08/09/23 in Formulas and Functions

I've used this formula multiple times and I am not sure what I am doing wrong on this sheet but I cannot get it to calculate. I have tried, =AVERAGEIF({CSB QA Report Range 1}, Name@row, {CSB QA Report Range 2}), I have tried =AVERAGEIF({CSB QA Report Range 1}, CONTAINS(Name@row, @cell), {CSB QA Report Range 2}), and also =AVG(COLLECT({CSB QA Report Range 2}, {CSB QA Report Range 1}, CONTAINS(Name@row, @cell), 0)). I keep getting #INCORRECT ARGUMENT SET. I really which there was a way to step into these formulas to see where the error is occurring.

The first range is the range that has the conditional date like employee names on the sheet that I am referencing, and the second range is what I want averaged based on the employee name in that row.


First Range

Second Range


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!