About Us

Don Guillett

Thanks for the catch Tom.

--
Don Guillett
SalesAid Software

"Tom Ogilvy" wrote in message
...
Don probably meant:

range("a1").formula= _
"=SUMPRODUCT((A2:A500=""string_a"")*(n2:n500=""str ing_2""))"

--
Regards,
Tom Ogilvy

"Don Guillett" wrote in message
...
range("a1").formula=
"=SUMPRODUCT((A2:A500="string_a")*(n2:n500="string _2"))"

--
Don Guillett
SalesAid Software

"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
i believe this will do want you need,

=SUMPRODUCT((A2:A500="string_a")*(n2:n500="string_ 2"))

--

Gary

"Prickle" <prick@somewherecom wrote in message
...
I'm struggling to get to grips with array formula and don't have much
time
left and so I am asking for your help to programatically enter a
fomula
that will count
the cells in Range(A2:A500) that contain String_A whose corresponding
cell
in Range(N2:N500) contains String_B

My grateful thanks in advance for any help

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Countif array formula	David	Excel Worksheet Functions	7	October 17th 06 04:29 PM
Array formula using two columns and countif	Dave	Excel Worksheet Functions	8	May 12th 06 07:02 PM
I need to create an array formula combined with a countif	Rochelle B	Excel Worksheet Functions	5	October 25th 05 05:12 AM
Countif array formula	Bruce	Excel Worksheet Functions	1	October 14th 05 08:46 AM
countif array formula	Rita	Excel Worksheet Functions	3	December 15th 04 04:44 AM