Forum Discussion
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...
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.
- Mathetes
i just sent you a private message explaining some stuff
