countif and dates

J

JAF

My spreadsheet includes a column with the date (mm/dd/yr) of the
entry. Can I use countif to count the number of entries that were made
in each month? Thanks, JAF
 
B

Biff

Hi!

Try this:

=SUMPRODUCT(--(MONTH(F1:F10)=1))

Replace the 1 with the appropriate month number.

Biff
 
P

Peo Sjoblom

Just a heads up in case there might be blank cells, the formula will count
blank cells as January

=SUMPRODUCT(--(MONTH(F1:F10)=1),--(ISNUMBER(F1:F10)))

will not


Regards,

Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using <= in countifs statement 1
Need help with using Month as criteria for SUM(COUNTIFS(... 3
VBA - exporting serial letters to single documents 0
Date Maniplation 1
Space at end of multi page list to accommodate new entries 1
Delete all data after a symbol in a field 0
Identical looking cells 2
countifs Function not giving desired result with date criteria 2

Top