Posted to microsoft.public.excel.worksheet.functions

chedd via OfficeKB.com chedd via OfficeKB.com is offline

external usenet poster

Posts: 22

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how can I fix a missing formula bar in Excel?	torajudo	Excel Worksheet Functions	6	June 28th 06 11:39 PM
formula missing something	mmock	Excel Discussion (Misc queries)	4	March 29th 06 01:30 AM
missing formula bar	Ron	New Users to Excel	2	September 28th 05 05:09 PM
Cell formula missing	Anthony	Excel Discussion (Misc queries)	7	July 14th 05 06:06 PM
Formula is missing	Shakeel	Excel Worksheet Functions	1	July 11th 05 12:20 PM

All times are GMT +1. The time now is 10:05 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us