I have an excel 2003 workbook with several worksheets - each a mirror image
of the others i.e. any particular cell has the same data (not literally)

Cell B6 contains a calculated age value and is in number format.

I am trying to do a count for the total number of worksheets broken down
into age bands

An example of the formula I am using is :-

=COUNTIF('A114_N:Seamas(4)'!$B$6,"=20")-COUNTIF('A114_N:Seamas(4)'!$B$6,
"24")

but I am getting the dreaded #VALUE! error

Any advice gratefully received

Bob

On Sep 24, 12:11 am, "Bob Matthews" wrote:
I have an excel 2003 workbook with several worksheets - each a mirror image
of the others i.e. any particular cell has the same data (not literally)

Cell B6 contains a calculated age value and is in number format.

I am trying to do a count for the total number of worksheets broken down
into age bands

An example of the formula I am using is :-

=COUNTIF('A114_N:Seamas(4)'!$B$6,"=20")-COUNTIF('A114_N:Seamas(4)'!$B$6,
"24")

but I am getting the dreaded #VALUE! error

Any advice gratefully received

Bob

I don't think COUNTIF can do 3D, actually there's a lot it can't do.
You can overcome this with a UDF or a far more complex formula since
not too many functions really do 3D. I use the UDF found in morefunc.
Search the net, or download.com to find it.

morefunc's function is called "COUNTIF.3D". Guess what it does.

You can try frequency instead:

=INDEX(FREQUENCY('A114_N:Seamas(4)'!$B$6,{19,24}), 2)

"Bob Matthews" wrote:

I have an excel 2003 workbook with several worksheets - each a mirror image
of the others i.e. any particular cell has the same data (not literally)

Cell B6 contains a calculated age value and is in number format.

I am trying to do a count for the total number of worksheets broken down
into age bands

An example of the formula I am using is :-

=COUNTIF('A114_N:Seamas(4)'!$B$6,"=20")-COUNTIF('A114_N:Seamas(4)'!$B$6,
"24")

but I am getting the dreaded #VALUE! error

Any advice gratefully received

Bob