Sum formula across multiple tabs and fields

[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!!!!

 

[rylv5050]

This didn't correct my formula but perhaps if I clarify my need, we can get
there.

On my summary sheet, I need to create a countif a2:a300 = X and G2:G300 = Y
then I want the # returned in each respective field. So count how many
Verizon/Cell Phones there are, Verizon/Black Berries there are,
ALLTEL/CellPhones etc. I should also point out that I need to count them
based on their alpha data but I just keep returning 0 with the ollowing
attempt:
=COUNTIFS('Battle Mountain'!A2:A300,ALLTEL,'Battle Mountain'!G2:G300,CELL
PHONE )

 

[Herbert Seidenberg]

Excel 2007 PivotTable
Consolidate multiple tabs.
With macro, no formulas.
http://www.mediafire.com/file/kjufwyoiyxy/08_11_09.xlsm