Forum Discussion
dottieddotdot
May 08, 2023Copper Contributor
formulas
I have several worksheets in 1 excel book that i have separating different information. I supervise a call center that services 16 different counties broken down into 14 different departments. On ea...
mathetes
May 08, 2023Gold Contributor
Do I understand correctly that you have a separate sheet for each day? Or is the basis for having separate spreadsheets in the single workbook something else?
In any event, the Excel Pivot Table often serves to deliver the kind of summary you appear to be seeking. No formulas required. The Pivot Table works most effectively, however, when pulling its data from a single table of data. Is it possible for you, without violating any privacy or confidentiality, to post a copy of the actual workbook? Put it on OneDrive or GoogleDrive and paste a link here that grants access to it.
If you are inclined to research such things on your own, here are two links to resources that describe the Pivot Table, how to set one up to analyze your data.
- ExcelJet has good materials on many aspects of Excel. Here's the page on the Pivot Table.
- YouTube has lots of videos. Here are some introductory videos on the Pivot Table.
- dottieddotdotMay 08, 2023Copper ContributorMathetes
i just sent you a private message explaining some stuff