Prev: Problem in Conversion of Excel to Text(Tab delimated)
Next: Protection
From: Lukcasem on 22 Mar 2010 05:48
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?
From: Bob Phillips on 22 Mar 2010 06:25
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" <Lukcasem(a)discussions.microsoft.com> wrote in message
news:57E970B6-76E7-45CD-AD7D-78CFBF28B84F(a)microsoft.com...
>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?


 | 
Pages: 1
Prev: Problem in Conversion of Excel to Text(Tab delimated)
Next: Protection