Try
=SUM(COUNTIF(INDIRECT("'"&{"Apr 07","May 07","Jun
07"}&"'!F27:F48"),"=18"))-SUM(COUNTIF(INDIRECT("'"&{"Apr 07","May 07","Jun
07"}&"'!F27:F48"),"20"))
--
Regards,
Peo Sjoblom
"chedd via OfficeKB.com" <u18187@uwe wrote in message
news:73e31fcc32c5a@uwe...
Hi
I am using a 3D formula =SUM(COUNTIF(INDIRECT("'"&{"Apr 07","May 07","Jun
07"}
&"'!F27:F48"),({"<18","<=20"})*{-1,1})) to count ages between certain age
groups, but keep getting a 0value to where there are 8 references between
the
ages of 18-20.
--
Message posted via http://www.officekb.com