young Ed
Veteran
come on i know we have a quite a few techies on here!
anyway how do i do a formula for the sum of all cells in a certain column that are also in a row with a certain word/phrase in it if that makes sense?
for example i am setting up a ride log in excel and i have a column for which bike i used as i have 2 different bikes
and i want a total for the number of miles covered on each bike so if miles for that ride are in column B starting in cell B2 and ending in cell B202 and the bike data is in column C starting in cell C2 and ending in cell C202 than i want excel to pick out the distance of all rides bike bike scott speedster 2009 and add all those distances together to give me a total distance covered by that bike and then a total distance in another cell for rides with bike as falcon trailfinder
i could label the bikes as A and B if that helps so the scott could be bike A and the falcon could be B if it would help excel?
Cheers Ed
anyway how do i do a formula for the sum of all cells in a certain column that are also in a row with a certain word/phrase in it if that makes sense?
for example i am setting up a ride log in excel and i have a column for which bike i used as i have 2 different bikes
and i want a total for the number of miles covered on each bike so if miles for that ride are in column B starting in cell B2 and ending in cell B202 and the bike data is in column C starting in cell C2 and ending in cell C202 than i want excel to pick out the distance of all rides bike bike scott speedster 2009 and add all those distances together to give me a total distance covered by that bike and then a total distance in another cell for rides with bike as falcon trailfinder
i could label the bikes as A and B if that helps so the scott could be bike A and the falcon could be B if it would help excel?
Cheers Ed