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

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

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

Jim Thomlinson


"torooo" wrote:

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

Try this:

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

--

HTH,

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

"torooo" wrote in message
...
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

On Dec 7, 11:44 am, "RagDyeR" wrote:
Try this:

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

--

HTH,

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

"torooo" wrote in message

...
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.

On Dec 7, 11:33 am, Jim Thomlinson <James_Thomlin...@owfg-Re-Move-
This-.com wrote:
Sumproduct is better with multiple conditions. Check out this link...

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

Jim Thomlinson



"torooo" wrote:
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- Hide quoted text -

- Show quoted text -

Thanks for your assistance. I learnt something new today.

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

Make sure you use that link that Jim posted.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"torooo" wrote in message
...
On Dec 7, 11:44 am, "RagDyeR" wrote:
Try this:

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

--

HTH,

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

"torooo" wrote in message

...
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.