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 )


"NBVC" wrote:


rylv5050;447485 Wrote:
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!!!!

IF you download and install a free addin called Morefunc.xll from he


'Morefunc - Free software downloads and software reviews - CNET
Download.com'
(http://download.cnet.com/Morefunc/30...-10423159.html)



you can then use the Countif.3D() function

e.g

=COUNTIF.3D(Sheet1:Sheet5!$A$1:$A$200,A1)

where Sheet1 is the first sheet and Sheet5 is the last sheet and
A1:A200 contain the vendor names in each sheet..... and A1 on active
sheet contains "Vendor 1" name to look for.

formula can be copied down.


--
NBVC

Where there is a will there are many ways.

'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=123927