Formula to locate all jobs in Month then break up into categories

L

Lukcasem

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?
 
B

Bob Phillips

Just add another condition

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

Lukcasem

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Grouping of Categories 1
Number of days left in the Month? 10
How can i add a line break into a formula in excel 2000? 9
Adjusting formula for month in vlookup? 3
Day of month to Date in month 2
Set Up Calendar To Account For Leap Years 2
if cell in other worksheet meets criteria, then leave blank. 1
trying to create a link to a link in Excel (2007) 3

Top