Masking numbers

[Ben51]

Hi All,

I have the following problem...

I have many numbers in the following format associated with several costs:

A B C

06.01.01.01.01 £8000 £40000
06.01.01.01.02 £2000 £50000
06.01.01.02.01 £9000 £60000
06.01.01.03.01 £7000 £70000
06.01.02.01.01 £5000 £40000
06.01.02.01.02 £1000 £30000

I wish to be able to add up all the costs associated with codes beginning with 06.01.01.01
and
06.01.02
etc

Thanks Guys and Girls

Ben

 

[Ben51]

Thankyou very much,

How would i omit something from the sumproduct?

i.e. 06.01.02.03 (in number form rather than cell reference?

 

[sheetspread]

Excel 2010
	A	B	C	D	E	F	G	H	I	J	K
1	06.01.01.01.01	6679	3119	8296	9416	3868	8804	8505	6064	5217	5181
2	06.01.01.01.02	7862	8942	2136	9698	5524	3625	4348	3463	6008	7800
3	06.01.01.02.01	2756	8350	3300	6457	9622	8751	8404	5533	1947	6035
4	06.01.01.03.01	7992	8919	8552	4697	3154	5892	7218	4550	9459	4200
5	06.01.02.01.01	7762	7512	1972	6681	6955	8577	3399	7734	9245	1967
6	06.01.02.03.02	7619	7299	3275	9923	3634	4746	7213	2407	2761	9656
7
8
9
10	06.01.01.01	312147
Sheet2

Cell Formulas
Range	Formula
B10	=SUMPRODUCT((LEFT($A$1:$A$6,11)<>"06.01.02.03")*B$1:K$6)