Dave T
05-05-2011, 11:22 PM
Hello All,
I am trying to get my head around how to do this...
I keep my rock climbing records in a spreadsheet and I want to produce a summary page of climbs I have done for a specific year and within a grade range. i.e.
I have a table layout as follows...
Date | Area | Climb Name | Grade
1/10/2010 | | | 15
1/10/2010 | | | 12
Formula results:
Sum of lead climbing metres for a specific year (column A) with a grade greater than or equal to 16 (column D)
Sum of lead climbing metres for a specific year with a grade greater than or equal to 12 and less than 16Any help or suggestions would be appreciated.
Regards,
Dave T
I am trying to get my head around how to do this...
I keep my rock climbing records in a spreadsheet and I want to produce a summary page of climbs I have done for a specific year and within a grade range. i.e.
I have a table layout as follows...
Date | Area | Climb Name | Grade
1/10/2010 | | | 15
1/10/2010 | | | 12
Formula results:
Sum of lead climbing metres for a specific year (column A) with a grade greater than or equal to 16 (column D)
Sum of lead climbing metres for a specific year with a grade greater than or equal to 12 and less than 16Any help or suggestions would be appreciated.
Regards,
Dave T