Try this:

=SUMPRODUCT((B3:B50="ARNECOM")*(C3:C50=DATE(2006, 1,1)*(C3:C50<=DATE(2006,1,1))))

--

HTH,

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

"Redwing ML" wrote in message
...
Hello Team,

I have two countif formulas that work perfectly for my spreedsheet in two
different cells. How can I merge them together to count only if they meet
both formulas and enter result in a third cell?

The formulas are as follows;

=COUNTIF(B3:B50,"ARNECOM")
=COUNTIF(C3:C50,"="&DATE(2006,1,1))-COUNTIF(C3:C50,"="&DATE(2006,2,1))

Hey, I thank you in advance!
Redwing ML