Building a summary table from another sheet

spinitback

Hi I'm creating a sheet "Summary Stats" from a base sheet called "Sheet 1"

Sheet 1 has many columns but of interest is

The alerts can be "100% Storage", "90% Storage", "80% Storage"

I want the populate the Summary Stats sheet to look like this

based on WeekOf, total Alerts, # of 100%,90%,80% alerts.

I tried a report but I just need a simple table and the report had groupings, expand/collapse.

I tried to create a sheet reference to Sheet1 with those columns, but I don't know how to reference a specific column within the sheet reference for a COUNTIFS formula.

Any help is appreciated, thanks

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

To reference a specific column, you would select only that column header when creating the cross sheet reference.

spinitback

Thanks Paul, so that would look like this? {Temp Table Reference}[Alert] ?

My goal is to create the total number of Alerts of "100% Storage" where the weekOf is "2024-08-19"

What would that formula look like?

TIA

Paul Newcome

No. When you create a cross sheet reference, you have to select which cell(s) will be referenced. If you just want to select a single column, you would simply click on the column header in question and use that for the cross sheet reference.

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.