|
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? |
Formula to locate all jobs in Month then break up into categories
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? |
Formula to locate all jobs in Month then break up into categor
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? . |
Formula to locate all jobs in Month then break up into categor
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? . |
Formula to locate all jobs in Month then break up into categor
What was the problem?
-- HTH Bob "Lukcasem" wrote in message ... 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? . |
| All times are GMT +1. The time now is 11:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com