13th June 2006, 03:40 PM
|
|
Member
|
|
Join Date: Jan 1970
Location: Sydney
Posts: 402
|
|
Quote:
|
Originally Posted by Twodogs
Following on the same track as above still 3 columns but I want to only add the 2 highest columns together then average them. Can that be done easily? Obviously there still could be a 0 in one or more columns.
Twodogs
|
=sum(a1:c1)-min(a1:c1)
or
=max(a1:c1)+median(a1:c1) |