Thanks Ron and Team!

This seems to work just fine!

However, how come I had to use "SUMPRODUCT" instead of my original "COUNTIF"
or mybe even "IF"("THEN".....?? or "IF"("COUNTIF"...etc..etc..?

Redwing ML



"Ron Coderre" wrote:

Yikes! Typo...
This
=SUMPRODUCT(--(B3:B50="ARNECOM"),--(C3:C50=DATE(2006,1,1)),--(C3:C50<=DATE(2006,2,1))

Should be:
=SUMPRODUCT(--(B3:B50="ARNECOM"),--(C3:C50=DATE(2006,1,1)),--(C3:C50<DATE(2006,2,1))

(I removed the last "=" from the formula)

--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"Ron Coderre" wrote in message
...
You'd need SUMPRODUCT for that:
=SUMPRODUCT(--(B3:B50="ARNECOM"),--(C3:C50=DATE(2006,1,1)),--(C3:C50<=DATE(2006,2,1))

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)


"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