Thursday, July 19, 2012

yogi_Tally Miles Run On Shoes By Year

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #640   Jul 19, 2012

user inabag said:(!category-topic/docs/spreadsheets/GSBN5TWOTgM)
Help with formula to tally mileage on shoes

Example Spreadsheet:
I am trying to track mileage on shoes worn when running. As you can see in Sheet1 column K, I have a dropdown selection box for which shoes I wore that run. On Sheet2 I have cells for each month. I want to tally how many miles were run on each shoe. So I need it to check for each shoe on that row, and find the miles in the appropriate column, and then tally all columns/rows for a total.
Help? Thanks.
following is a solution to the problem
1) in Sheet1, I added a run date in year 2011 with shoe name Yogi
2) in Sheet1, where no shoes were shown with some runs, i added the shoe name as Yogi