Excel problema

[jayeliz]

hiyall

nother problema for the excel gurus. I'm doing a count on a workboo
with multiple sheets. I am counting the initials of instructors an
placing the result in a cell in a different workbook. So far I'm using
=COUNTIF('[Q.C. TIME STUDIES1.xls]AGUILAR, A.'!$B$9:$B$38,"ADA") whic
only works for one sheet. But if I select all the sheets and us
=COUNTIF('[Q.C. TIME STUDIES1.xls]AGUILAR, A.:YAWS
J.'!$B$9:$B$38,"ADA") I get the #VALUE! error. I read that its no
possible to do a 3d countif. Is there any way to accomplish thi
another way. Any help would surely be appreciated. Thanks

 

[Dave R.]

Go to
http://longre.free.fr/english/

you can use THREED or COUNTIF.3D to do the job, and the
instructions/examples in the help file are quite clear.

 

[Frank Kabel]

Hi
You may try to download the free add-in Morefunc.xll
(http://longre.free.fr/english). The function COOUNTIF.3D should work
for you:
=COUNTIF.3D('[Q.C. TIME STUDIES1.xls]AGUILAR,
A.:YAWS,J.'!$B$9:$B$38,"ADA")

 

[jayeliz]

Thanks guys! Once again you pulled through.