COUNTA - date driven

  • Thread starter Thread starter Karen
  • Start date Start date
K

Karen

How can I count the number of non-blank entries on one
column only if another column in the row matchs a date

Column A Column B
1234 3/4/04
3/5/04
2234 3/15/04
3234 2/5/04

I want to count how many entries in column A are from the
month of March so I'm looking for a result of 2 from the
example above.

Thanks,
Karen
 
One way:

=SUMPRODUCT(--(A1:A20<>""),--(MONTH(B1:B20)=3))

The 3 represents March. 1=Jan.,2=Feb., etc.

HTH
Jason
Atlanta, GA
 
or more obviously

=SUMPRODUCT((A1:A20<>"")*(TEXT(B1:B20,"mmm")="Mar"))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top