Home |
Search |
Today's Posts |
#1
|
|||
|
|||
countif and dates
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 |
#2
|
|||
|
|||
Hi!
Try this: =SUMPRODUCT(--(MONTH(F1:F10)=1)) Replace the 1 with the appropriate month number. Biff -----Original Message----- 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 . |
#3
|
|||
|
|||
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 "Biff" wrote: Hi! Try this: =SUMPRODUCT(--(MONTH(F1:F10)=1)) Replace the 1 with the appropriate month number. Biff -----Original Message----- 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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|