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.