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!!!! |
All times are GMT +1. The time now is 08:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com