R
rylv5050
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!!!!
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!!!!