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