yogi_Tally Miles Run On Shoes By Year

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


user inabag said:(http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/GSBN5TWOTgM)
Help with formula to tally mileage on shoes

Example Spreadsheet:

https://docs.google.com/spreadsheet/ccc?key=0AhEsUaudJxrPdE9ld1lRV0xHc0hKUm5qdDk1dnR3NVE

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

note:

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