Creating summary from one sheet

[LisaUK]

Hi All,

I have a sheet of information in excel 2007 and it is made up as follows


Company Sales Month
ABC 1000 Jan 10
ABC 15000 Jan 10
123 200 Feb 10
ABC 5500 Jan 10
567 900 Mar 11
ABC 300 Feb 11



As I have multiple entries for each company for the same month what I am trying to get to is


Company Sales Month
ABC Total Sales For the Month of Jan 10
ABC Total Sales For The month of Feb 10
123 Total Sales For the Month of Jan 10



Etc

I hope it makes sense, so I am trying to break down each company total sales by month from the data I already have, any ideas would be appreciated.

Thank you

Lisa

 

[LisaUK]

Mick I just tested it and looks great, all working!

THANK YOU!