Friday, July 22, 2011

yogi_Compute Average Of Numbers In Specified Columns By Row

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  
bztkd said:
Averaging Columns
I have a spreadsheet with 6 columns.
I need Column F to be the average of Columns C,D and (sometimes) E. If E is not to be included in the average the cell will be left blank. Columns C,D, and E are all numbers. How do I go about doing this?