formulas in worksheets/workbooks
 

I have created a workbook in excel. I am tracking dates of completion. I also
want to track how many items were completed in each month. What I would like
to do is enter the date of completion in the spreadsheet and have it
calculate a total number for the month. ie: I input three jobs that were
completed in the month of February, on another spreadsheet, I need a formula
that says "if this space has a date of Febraury XX (anything) then is is
"ticked" on the other spreadsheet. So it will see that there were 3 jobs with
a February completion date so there would be a number 3 in the spreadsheet
for the totals.

formulas in worksheets/workbooks
 

=SUMPRODUCT(--(MONTH(B14:B19)=2))

Assuming the dates are in B14:B19.


"Steve" wrote:

I have created a workbook in excel. I am tracking dates of completion. I also
want to track how many items were completed in each month. What I would like
to do is enter the date of completion in the spreadsheet and have it
calculate a total number for the month. ie: I input three jobs that were
completed in the month of February, on another spreadsheet, I need a formula
that says "if this space has a date of Febraury XX (anything) then is is
"ticked" on the other spreadsheet. So it will see that there were 3 jobs with
a February completion date so there would be a number 3 in the spreadsheet
for the totals.