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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>