=SUMPRODUCT(--(TEXT(A2:A100,"mmmm yyyy")="Octobober
2006"),--(O2:O100="Maintenance"))


"Heliocracy" wrote:

For each record, Column B is a date and Column O is either "Maintenance" or
"Routine." How do I count the number of "Maintenance" records whose dates
fall within a specific month--ex: count number of records that are dated
anytime in October 2006 (in column B) AND have the word "Maintenance" (in
column O)?