View Single Post
Old 02-26-2010, 12:26 AM
BjornS BjornS is offline Windows Vista Office 2003
Competent Performer
Join Date: Jan 2010
Location: Sweden
Posts: 116
BjornS is on a distinguished road

I couldn't resist that challenge! I attach solution number 4 (hopefully the last) with a general formula.

The number 3 in the formula (twice) is number of lines skipped. The number 10 in the formula (twice) is the first row with data to sum.

Kind regards
Attached Files
File Type: xls Temperatures_by_quarter_General_formula.xls (28.0 KB, 21 views)
Reply With Quote