Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count formula across tabs
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!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula between tabs | Excel Discussion (Misc queries) | |||
count tabs | Excel Discussion (Misc queries) | |||
Count through tabs | Excel Discussion (Misc queries) | |||
Page Count with Tabs | Excel Discussion (Misc queries) | |||
Is there a way to count all the worksheet tabs in an Excel speadsh | Excel Discussion (Misc queries) |