Dates - Several Days In a month to month only

Problem below

14-Oct-06 £5,000
30-Oct-06 £15,000

How do I get this to show as:

Oct-06 £20,000

Is there a formula to do this?

="Oct-06 "&TEXT(SUMPRODUCT(--(MONTH(A1:A100)=10),B1:B100),"£#,##0")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Andy_Pimp" <Andy_Pimp.23xqon_1141123204.639@excelforum-nospam.com> wrote in
message news:Andy_Pimp.23xqon_1141123204.639@excelforum-nospam.com...
>
> Problem below
>
> 14-Oct-06 £5,000
> 30-Oct-06 £15,000
>
> How do I get this to show as:
>
> Oct-06 £20,000
>
> Is there a formula to do this?
>
>
> --
> Andy_Pimp
> ------------------------------------------------------------------------
> Andy_Pimp's Profile:
http://www.excelforum.com/member.php...o&userid=31990
> View this thread: http://www.excelforum.com/showthread...hreadid=517243
>