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