Your formula looks good. Could you post what data/dates you have entered, as
well as what your formula is currently returning(compared to what it should)?
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"mbeemom" wrote:

I'm stumped. I have two worksheets where I count the occurrences of the work
order type by month from the first worksheet and get a running tally in a
table on the second worksheet. My results have been accurate until I arrived
at January. Column C is WS2 is accurate but columns D & E no longer tally
and count the blank cells which never happened in the past. Nothing has
changed except for the month value. Here is the set up:

Worksheet 1 is "Work Orders" Worksheet 2 is Totals FY 2009
Worksheet 1:
Column b is the Work Order Type
Phone Request
Telephone Trouble
Trouble Calls
Work Request
Column c is the date received
column d is the date started
column e is the date completed

Here is my formula:
=SUMPRODUCT(--('WORK ORDER'!B2:B701="Telephone Trouble"),--(--MONTH('WORK
ORDER'!D2:D701)=1))