Try:
=SUMPRODUCT((B3:B50="ARNECOM")*(C3:C50=DATE(2006, 1,1))*(C3:C50<DATE(2006,2,1)))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Redwing ML" wrote:
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