Hello,
I have been trying to write a formula to pull the averages of numbers in each column by Leader into a separate sheet but the only formula I could find that can calculate this is working, but pulling the data as zero. Is the issue because this is data generated from a form?
The equation I am using is =AVERAGEIF({30-Day Check-In: Standardization Process Range 6}, =Leader@row) - it's pulling data from another sheet, BUT for every leader, it is coming up as zero. Please Help!