Dates - Several Days In a month to month only

A

Andy_Pimp

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?
 
B

Bob Phillips

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top