Hi there,
I created a social media content calendar and was manually entering data relevant to each column on the "Content" sheet. My "Analytics" sheet was summing and averaging Facebook/Twitter/Instagram/LinkedIn/YouTube Likes, Comments, Reach, etc. for the months of APR and MAY but stopped summing/averaging Facebook data for JUN and JUL. In other words, the Twitter/Instagram/LinkedIn/YouTube formulas appear to be working for JUN and JUL but the Facebook formulas are not working for JUN and JUL. I used the exact same formulas in JUN and JUL that I did in APR and MAY.
=SUMIFS(tblEvents[ENGAGEMENT],tblEvents[MONTH],"JUN",tblEvents[CHANNEL & HEADLINE],"*Facebook*",tblEvents[BOOSTED?],"No")
=AVERAGEIFS(tblEvents[ENGAGEMENT],tblEvents[MONTH],"JUN",tblEvents[CHANNEL & HEADLINE],"*Facebook*",tblEvents[BOOSTED?],"Yes")
I simplified the workbook to show what I mean.
Thanks in advance for your help.
Bookmarks