View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
chedd via OfficeKB.com chedd via OfficeKB.com is offline
external usenet poster
 
Posts: 22
Default zero value from using 3D formula, value is missing

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