Found the problem. Thanks for your help. It is great.

"Lukcasem" wrote:

I tried what you suggested but it keeps coming up with an error and drops the
comma before the last condition. Not quite sure what to do from here.

"Bob Phillips" wrote:

Just add another condition

=SUMPRODUCT(--(MONTH('Nikkis Working'!A2:A1000)=MONTH(A2)),
--(YEAR('Nikkis Working'!A2:A1000)=YEAR(A2)),
--('Nikkis Working'!B2:B1000="Accepted"))

--

HTH

Bob

"Lukcasem" wrote in message
...
I have a workbook with a worksheet displaying all the jobs I have in
different categories.

I would like to display on the my worksheet "Nikkis Critical Data" a break
up of jobs per month - Which I have done using
=SUMPRODUCT(--(MONTH('Nikkis
Working'!A2:A1000)=MONTH(A2)),--(YEAR('Nikkis
Working'!A2:A1000)=YEAR(A2))).
Then I would like to break each of the monthly figures up into three
categories - Accepted, Not Accepted and Pending (which are currently
listed
in Column B in Nikkis Working Worksheet.

Is it possible? If so, how?


.