Summary Report Formula

I have a sheet with the following columns

I need to create a quarterly dashboard finding the total of each channel by quarter. I am currently doing this formula in summaries:

=COUNTIFS(Quarter:Quarter, "Qtr 1", Channel:Channel, "Search")

My question is, is there a better way to get values? There are a lot of channels and I havent even made a dent in q1. PLEASE HELP!!!

Find more posts tagged with

Accepted answers

All comments

@NikkiC I can think of 2 ways right now on how to set a template (Sheet) for the calculations, see below; it all depends on how you need it. Use the absolute reference ($) in the functions to make it easier when dragging (or copy/paste) the formula.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.