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.
|