Countif with multiple conditions

[torooo]

I am trying to create a formula that counts based on the following
criteria:

COUNTIF($c$2:$c$9,"abc") - COUNTIF($A$2:$A$9,text="C") - in using ABC
as an example, I would have 2 for ABC


A B C D E
C 01-Dec ABC 60 88hn
12 04-Dec ABC 70 875k
1555 12-Dec EDF 5600 656
1455 04-Dec DEF 1222 9665jkk
7 08-Dec ABC 10 856ui
45 30-Nov FGJ 2 ko745
36 10-Dec LMK 1 pop
C 14-Feb CBD 0 7a

Thanks in advance

 

[Jim Thomlinson]

Sumproduct is better with multiple conditions. Check out this link...

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

 

[RagDyeR]

Try this:

=SUMPRODUCT((C2:C9="abc")*(A2:A9<>"c"))

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I am trying to create a formula that counts based on the following
criteria:

COUNTIF($c$2:$c$9,"abc") - COUNTIF($A$2:$A$9,text="C") - in using ABC
as an example, I would have 2 for ABC


A B C D E
C 01-Dec ABC 60 88hn
12 04-Dec ABC 70 875k
1555 12-Dec EDF 5600 656
1455 04-Dec DEF 1222 9665jkk
7 08-Dec ABC 10 856ui
45 30-Nov FGJ 2 ko745
36 10-Dec LMK 1 pop
C 14-Feb CBD 0 7a

Thanks in advance

 

[torooo]

Try this:

=SUMPRODUCT((C2:C9="abc")*(A2:A9<>"c"))

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


I am trying to create a formula that counts based on the following
criteria:

COUNTIF($c$2:$c$9,"abc") - COUNTIF($A$2:$A$9,text="C") - in using ABC
as an example, I would have 2 for ABC

A B C D E
C 01-Dec ABC 60 88hn
12 04-Dec ABC 70 875k
1555 12-Dec EDF 5600 656
1455 04-Dec DEF 1222 9665jkk
7 08-Dec ABC 10 856ui
45 30-Nov FGJ 2 ko745
36 10-Dec LMK 1 pop
C 14-Feb CBD 0 7a

Thanks in advance

Thanks for your assistance. I learnt something new today.

 

[torooo]

Sumproduct is better with multiple conditions. Check out this link...

http://www.xldynamic.com/source/xld.SUMPRODUCT.html
--
HTH...

Jim Thomlinson








- Show quoted text -

Thanks for your assistance. I learnt something new today.

 

[RagDyer]

You're welcome, and appreciate the feed-back.

Make sure you use that link that Jim posted.