Hi, can you help me sort this workbook I created? I have 5 weeks worth of
data with different client names in all the sheets. How can I generate a
formula that totals only the result from column Q for the client name
(creekside) keep in mind that the positioning of the client will be in a
different place in the next sheets, examlpe: this is a copy of sheet1
(K32) (M32) (N32) (O32) (P32)
(Q32)
Creekside 263,643 6 $5.67 $7.08 $12.75

this is sheet2

(K57) (M57) (N57) (O57) (P57)
(Q57)
Creekside 263,764 12 $1.67 $9.08 $158.98

I need to add all the activity in column Q but how do I reference the name
Creekside.
I hope I could explain it.
thanks for your help


--
Louie