excel function problem
 

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

excel function problem
 

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.

excel function problem
 

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