Building a summary table from another sheet
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
Answers
-
To reference a specific column, you would select only that column header when creating the cross sheet reference.
-
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
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!