COUNTIF is not applicable as a 3D function.
Insert 2 new worksheets and name them First and Last. Place the relevant worksheets between First and Last.
This function is part of the morefunc.xll add-in which you need to download & install.
Addendum. Otherwise, follow Ogilvy's advise.
- Download morefunc
- For more on morefunc, see Function Descriptions
[ This Message was edited by: Aladin Akyurek on 2003-01-26 17:12 ]