help

[Monty]

Can anyone out there help me with setting up a graph for the following info.
See bottom of page for example of what i am looking
Cost Centre Received in Finance No Days
2010 May-04 29
2010 May-04 15
2010 May-04 21
2001 May-04 14
2026 June-04 34
2038 June-04 30
2010 May-04 17
2028 June-04 39
2010 May-04 26
2032 June-04 15
2027 June-04 13
2017 June-04 18
2017 June-04 17
2017 June-04 21
2001 June-04 21
2038 June-04 19
2037 June-04 30
2034 June-04 15
2017 June-04 24
2038 July-04 15
2017 July-04 20
2021 July-04 27
2027 June-04 107
2021 July-04 17
2028 July-04 28
2032 July-04 76
2027 July-04 76
2032 July-04 71
2022 August-04 24
2026 August-04 33
2028 August-04 36
2028 August-04 55
2002 August-04 16
2022 August-04 33
2022 August-04 33
2022 August-04 33

I would like the report to run monthly with the cost centre on the y axis
and the amount of days on the X axis. I have set out the month of June as an
example.

Ie CC 2027 month of June-04 = 120 Days Two occasions
2026 “ “ = 34 “ One “
2038 “ “ = 49 “ Two “
2028 “ “ = 39 “ One “
2032 “ “ = 15 “ One “
2017 “ “ = 70 “ Four “
2001 “ “ = 21 “ One “
2037 “ “ = 30 “ One “
2034 “ “ = 15 “ One “


thanks
M

 

[Bob Phillips]

Assuming first CC in D2, the date in E2, try

="CC"&D2&" month of "&TEXT(E2,"mmmm-yyyy")&" =
"&SUMPRODUCT(--(A2:A100=D2),--(MONTH(B2:B100)=MONTH(E2)),C2:C100)&" Days
"&SUMPRODUCT(--(A2:A100=D2),--(MONTH(B2:B100)=MONTH(E2)))&" occasions"

and update

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Monty]

this returns 0 days and 0 occasions

thanks

Assuming first CC in D2, the date in E2, try

="CC"&D2&" month of "&TEXT(E2,"mmmm-yyyy")&" =
"&SUMPRODUCT(--(A2:A100=D2),--(MONTH(B2:B100)=MONTH(E2)),C2:C100)&" Days
"&SUMPRODUCT(--(A2:A100=D2),--(MONTH(B2:B100)=MONTH(E2)))&" occasions"

and update

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Bob Phillips]

make sure that you correct the wrap-around that the NG throws up, it should
all be 1 line in the formula bar.

--

HTH

RP
(remove nothere from the email address if mailing direct)