Thread
:
Help Please - CountIf and Array formula
View Single Post
#
6
Posted to microsoft.public.excel.programming
Tom Ogilvy
external usenet poster
Posts: 27,285
Help Please - CountIf and Array formula
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
Reply With Quote
Tom Ogilvy
View Public Profile
Find all posts by Tom Ogilvy