Thread
:
Query for data in an array
View Single Post
#
3
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
Query for data in an array
=sumproduct((a2:a22="a")*(b2:b22="B")*(c2:c22="S") )
Does NOT have to be array entered
--
Don Guillett
SalesAid Software
"anonymous" wrote in message
...
I have data that is arranged as below
Column Name Col1 Col2 Col3
a b s
a c w
b d s
b c w
a d w
I want to count number of s in col3 where col1 = a and
col2 = b
I am trying to use array formula using countif and if
functions, but i am getting value#
Can some one tell me the right way to get the result
thanx
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]