one method
use two helper columns (E,F?)
in E1
=a1
in e2
=if(and(B1=B2,C1=C2,D1=D2),E1+A1,A1)<-----
in F1
=if(and(B1=B2,C1=C2,D1=D2),"",1)


copy E2 and paste to the end of your data

copy f1 and paste to the end of your data

select columns E and F
copy and paste special values
select column F and filter-autofilter
select blanks
select the visable cells and edit-delete rows
remove autofilter
select column E copy ans select Cell a1
paste spectial values

(It sounds more complicated than it is, but make sure you first try it on a
copy of your data)


(Me) YOU'VE DONE IT!!! AWESOME!!!


Kewl I can't Thank You enuf...
A few little tweaks and it worked!
this is how it worked for me.....


one method
use two helper columns (E,F?).......(changed because of there was a row "e")
in F1
=A1
in F2
=if(and(B1=B2,C1=C2,D1=D2,E1=E2),F1+A1,A2)<-----
in G1
=if(and(B1=B2,C1=C2,D1=D2,E1=E2),"",1)


copy F2 and paste to the end of your data

copy G1 and paste to the end of your data

select columns F and G
copy and paste special values
select column G and filter-autofilter
select blanks
select the visable cells and edit-delete rows (execpt the first row)
remove autofilter
select column F copy ans select Cell a1
paste spectial values


Wow, this crash course in EXCEL is still making my head spin.
many thanx,
mike