Why am I not getting the same average value in my formula compared to the sheet?

Kathy PPT

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

Kathy PPT

Thanks @Jennifer Kurtz.

My calculation is showing correctly at 97% now. I think SS had to catch up with itself. :)

Jennifer Kurtz

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.)

Kathy PPT

Hi @Jennifer Kurtz

Thank you for your reply. Here is the original sheet with filters.

When I highlight the CSAT column it summarizes as

Jennifer Kurtz

@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…

Kathy PPT

Thanks @Jennifer Kurtz.

My calculation is showing correctly at 97% now. I think SS had to catch up with itself. :)