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

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

Hi Anne

I have tried to interpret these pages, however, still struggling

I have sheets named, 1,2,3,4 etc. All the persons names in these sheets are
always in column A, and the cell i require is next to it, on the right.

In my summary sheeet, i have the sheet names in B2,C2, D2, etc. the names of
the people in column A3,A4 etc

I have tried =sumif(A3:A5,"Dave",B2&!A2:A5,B2&!B2:B5) obviously with no joy

Can you help me out?

regards



Anne Troy wrote:
Try to find the appropriate SUM/SUMIF example he
http://www.officearticles.com/excel/index.htm
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
Hi
I have looked on threads for summary sheet, with or without VBA, however,
[quoted text clipped - 8 lines]

Brian

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