From that list, I don't see anything that will count text strings in 3-d. So
I am guessing that I will have to make a cell on each page that corrosponds
with the particular text string that I am attempting to count? Is there any
other way to accomplish this. I have around 40 sheets and 12 seperate text
strings that I am going to be counting.

"Ron Rosenfeld" wrote:

On Tue, 19 Jun 2007 04:07:03 -0700, skijsh1979
wrote:

does any thing work in 3d?


Usually the quickest way to answer these kinds of questions is to look at HELP
for your particular product.

For example, in Excel 2003:


Functions that can be used in a 3-D reference

SUM - adds numbers
AVERAGE - calculates average (arithmetic mean) of numbers
AVERAGEA - calculates average (arithmetic mean) of numbers; includes text and
logicals

COUNT - counts cells that contain numbers
COUNTA - counts cells that are not empty
MAX - finds largest value in a set of values
MAXA - finds largest value in a set of values; includes text and logicals
MIN - finds smallest value in a set of values
MINA - finds smallest value in a set of values; includes text and logicals
PRODUCT - multiplies numbers
STDEV - calculates standard deviation based on a sample
STDEVA - calculates standard deviation based on a sample; includes text and
logicals

STDEVP - calculates standard deviation of an entire population
STDEVPA - calculates standard deviation of an entire population; includes text
and logicals

VAR - estimates variance based on a sample
VARA - estimates variance based on a sample; includes text and logicals
VARP - calculates variance for an entire population
VARPA - calculates variance for an entire population; includes text and
logicals


--ron