View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lukcasem Lukcasem is offline
external usenet poster
 
Posts: 3
Default Formula to locate all jobs in Month then break up into categories

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?