Why am I not getting the same average value in my formula compared to the sheet?
My formula shows average of .3625 (rounding up won't even help)
The sheet shows average of .97 (which is correct). The values outlined in blue are MS
Best Answer
-
Thanks @Jennifer Kurtz.
My calculation is showing correctly at 97% now. I think SS had to catch up with itself. :)
Answers
-
That is puzzling! Any chance there are some rows labeled "MS" on your data source that you missed in the screenshot? Or perhaps some of the "MS" rows aren't being labeled in the same way? (If you'd like, and can include a screenshot with the "Type" range included, that might help to troubleshoot.)
-
Thank you for your reply. Here is the original sheet with filters.
When I highlight the CSAT column it summarizes as
-
@Kathy PPT - Thanks for the screenshot!
The only other thing I can think to check is the ranges you've defined in the formula, to make sure they're pulling everything as intended…
-
Thanks @Jennifer Kurtz.
My calculation is showing correctly at 97% now. I think SS had to catch up with itself. :)
Help Article Resources
Categories
Check out the Formula Handbook template!