Try to find the appropriate SUM/SUMIF example he
http://www.officearticles.com/excel/index.htm
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"BNT1 via OfficeKB.com" <u19326@uwe wrote in message
news:6f9403a9b7d8b@uwe...
Hi
I have looked on threads for summary sheet, with or without VBA, however,
my
sheets in the work book are all the same format, except that the names in
column A are not always in the same order. and therefore using the same
cell
on each sheet is not an option
Can anyone suggest a way forward?

thanks

Brian

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200703/1