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

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