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

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.