checking two condtions

[sunil.s]

Hi,

I want the number of counts when two conditions are satisified

for ex:

a 1 completed
b 2 completed
b 3 completed
a 4 inprocess
d 5 completed
e 6 completed
a 7 completed

I wan to get the count of a with the completed status and also I want
to get the count a which is inprocess. I tried with countif function
but it's not working.


Could some one help me out

Thanks
Sam

 

[Peo Sjoblom]

=SUMPRODUCT(--(A1:A10="a"),--(C2:C10="completed"))

or

=SUMPRODUCT(--(A1:A10=D2),--(C2:C10=E2))

where you put the criteria in the cells

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon

 

[sunil.s]

It's not working

 

[Viquar]

Database(From A1)
Head1 Head2 Head3
a 1 completed
b 2 completed
b 3 completed
a 4 inprocess
d 5 completed
e 6 completed
a 7 completed


Criteria (From F1)
Head1 Head2 Head3
a completed

Formula

=DCOUNTA(A1:C8,A1,F1:H2)

 

[Harlan Grove]

Peo Sjoblom wrote...

=SUMPRODUCT(--(A1:A10="a"),--(C2:C10="completed"))

or

=SUMPRODUCT(--(A1:A10=D2),--(C2:C10=E2))

....

The arrays must be the same size, so either

=SUMPRODUCT(--(A1:A10="a"),--(C1:C10="completed"))

or

=SUMPRODUCT(--(A2:A10="a"),--(C2:C10="completed"))

depending on whether row 1 should be included or not, respectively.

 

[Peo Sjoblom]

There was a typo, see Harlan's answer

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon