This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I am working in communications so I'm auditing our company blogs from leadership and trying to find the average views/likes/comments based on the type of content (Company strategy/insight, company update, customer spotlight, event recap, inspirational, instructional, personal reflection).
My function looks like this =AVERAGEIF(Breakdown!G:G,"Company Strategy/Insight",Breakdown!D:D) Where the "type of content" is in column G:G on the tab titled "Breakdown" and the views per post are in the D:D column on the "Breakdown" tab.
However, I went into my table to check for accuracy and filtered my table by "type of content" and took the average of the views and ended up with a very different answer. I've messed around with this for about an hour and I can't figure out why I keep getting two different answers.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Your text for "Company Strategy/Insight" may have leading/trailing spaces that is not being included in the AVERAGE function. Use the TRIM function in another column to clean the data in column G and then paste special values over top of column G and try again.