formulas

Question

I have several worksheets in 1 excel book that i have separating different information.&nbsp; I supervise a call center that services 16 different counties broken down into 14 different departments. On each sheet (see below under County) i have a column that drops down to select one of the 16 different counties. in the next 14 columns I have headings for the 14 different departments.&nbsp; I'm needing a formula to calculate how many people called per county and per department.&nbsp; This book is for each day of the month.&nbsp; Example: I'm needing a total of how many people in Muscogee called for EH, and DCS and all the other titles across the top then total up the entire month.&nbsp; Can someone please assist me with this.&nbsp;CALL TIMEPHONE # OR&nbsp; CHAT #COUNTYEHDCSVRWICNON DPHFPIMMMISC DPHSTDDENTALWELLNESS LABSCOVIDHANG UPSTRANSFER TO FD&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1:21 AM-111616 - Webster&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1:26 AM-11171 - Muscogee1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2:07 AM-11181 - Muscogee&nbsp;&nbsp;&nbsp;&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2:24 AM-11191 - Muscogee&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

mathetes · Answer

dottieddotdot&nbsp;&nbsp;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?&nbsp;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.&nbsp;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.

dottieddotdot · Answer

Mathetesi just sent you a private message explaining some stuff

Forum Discussion

formulas

2 Replies