Posted to microsoft.public.excel.worksheet.functions

GerryK

Posts: n/a

Count If Array Formula

=SUM(IF(FREQUENCY(IF((A1:A100="directed")*(B1:B100 =60)*(C1:C100=285),MATCH(D1:D100,D1:D100,0),""),IF ((A1:A100="directed")*(B1:B100=60)*(C1:C100=285),M ATCH(D1:D100,D1:D100,0),""))0,1))

(Ctrl + Shift + Enter) in some cell to count for the first 100 records.

HTH
GerryK

"carl" wrote:

I am trying to build an array formula that will count the number of unique
values in Col D subject to the value in ColA="Directed", ColB=60, ColC=285.

Is it possible ?

Thank you in advance.

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
Array	Brad	Excel Worksheet Functions	9	October 17th 05 09:00 PM
Editing Array Formula	[email protected]	Excel Worksheet Functions	7	August 28th 05 06:46 AM
Array Formula - using LEFT("text",4) in formula	Andrew L via OfficeKB.com	Excel Worksheet Functions	2	August 1st 05 02:36 PM
Count if array contains cells of a certain value	Melissa	Excel Worksheet Functions	2	July 29th 05 02:37 AM
Array Formula, noncontigous range	Werner Rohrmoser	Excel Worksheet Functions	1	June 22nd 05 12:11 PM

All times are GMT +1. The time now is 04:37 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us