Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum formula across multiple tabs and fields
I have a workbook with multiple tabs and a summary screen that totals counts
of cell phones by site. Each tab is a site with users and their cell phone data, including cellular type, vendor etc. The summary screen looks like this but there are 7 total types of cell phone for each of 4 vendors: A B C D E 1 Location A Vendor A Cell Phone Count Black Berry Count Palm 2 Vendor B 3 Vendor C 4 Vendor D Each Tab is a location "Location A", Location B etc. and I want to insert formulas in C1-C4, D1-D4 on this summary page that will look to every vendor tab and pull the count for Vendor which is in colum A2-A1000 and Cell Phone type in G2-G1000. This formula should give me an accurate count of devices by vendor which will change autmatically when the tabs of locations changes dynamically. I appreciate it!!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to count based on multiple criteria fields w/duplicates | Excel Worksheet Functions | |||
Average Over Multiple Sheet Tabs with Multiple Values | Excel Worksheet Functions | |||
Multiple Fields In Multiple Ranged Pivot Table | Excel Discussion (Misc queries) | |||
SUMIF formula that crosses multiple sheet tabs | Excel Discussion (Misc queries) | |||
How do pivot table source fields automatically create tabs | Excel Worksheet Functions |