View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Redwing ML Redwing ML is offline
external usenet poster
 
Posts: 3
Default How to marry two working countif formulas?

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