Autofill/Reference Confusion
 

Hi all

I have 5 seperate worksheets with multiple data entered(namely Bike Ride etc
in Excise type).

What I am looking at doing is creating a summary sheet as per below, however
I am unsure how to autofill/reference more than 2 roes, as per table below.

Thanks for any assistance.

Patrick

Date Exercise Type Distance (km) Laps Total Time (Min) Avg Speed
(km/h) Avg Exercise HR In HR Zone Weight Factor
1/1/2005 Bike Ride 13.34 40.40 19.81 143 27.29 0.00
Swim 0.00 0.00 0.00 #DIV/0! 0.00 0.00 0.00
Run 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Weights 0.00 0.00 0.00 0.00 0 0.00 22.50
Yomp 0.00 0.00 0.00 0.00 0 0 0.00
Totals 13.34 40.40 #DIV/0! 143 27.29 22.50
1/2/2004 Bike Ride 13.69 40.30 20.38 143.5 21.29 0.00
Swim 0.00 0.00 0.00 #DIV/0! 0.00 0.00 0.00
Run 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Weights 0.00 0.00 0.00 0.00 0 0.00 0.00
Yomp 1.50 0.00 50.00 1.80 129 7.615 0.08
Totals 15.19 90.30 #DIV/0! 136.25 28.91 0.08