Posted to microsoft.public.excel.misc

joeu2004

external usenet poster

Posts: 2,059

Why doesnt union reference operator work with COUNTIF?

And why doesn't the union reference operator work in this context?

=COUNTIF((A1:F1,M1:Z1),10)

Yes, I know the workaround in this case: the sum of two COUNTIFs.
That's not the issue. The point is: the union reference operator
works with some functions -- e.g. IRR((A1,B1:B5,C1),7%) -- but not
with others. Why?

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
COUNTIF cell reference won't work	Kenny Newbry	Excel Worksheet Functions	4	June 26th 07 07:59 PM
reference to other sheet doesnt work	Jan	Excel Worksheet Functions	3	August 21st 06 08:48 PM
countif function doesnt work	TimekeeperTim	Excel Worksheet Functions	2	May 20th 06 10:55 AM
COUNTIF doesnt work!	jjj	Excel Worksheet Functions	2	September 30th 05 02:38 AM
Formula doesnt work	Kevin	Excel Worksheet Functions	2	February 24th 05 12:57 AM

All times are GMT +1. The time now is 02:14 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us