| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? . |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? . |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count categories in one column if within particular month | Excel Worksheet Functions | |||
| How to get a line to locate at the page break in excel | Excel Discussion (Misc queries) | |||
| Locate month n year from range of date | New Users to Excel | |||
| Locate month and year from range of date from another sheet | New Users to Excel | |||
| How do I break a date range by month? | Excel Discussion (Misc queries) | |||
Linear Mode
