How to marry two working countif formulas?
Typo in the second date.
Use Max's!
--
Regards,
RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------
"RagDyeR" wrote in message
...
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
|