Simple Average??

  • Thread starter Thread starter GBL
  • Start date Start date
G

GBL

Hi Guys & Gals:
My problem is to obtain an average from selected row-cells that are
separated (non-contiguous). For example:

A D F H K
2 3 4 1 = 2.5
2 3 4 = 3
2 2 = 2
First, notice that all of the columns above are numeric; but may contain
blanks. Second, the pertinent columns are fixed (always A, D, F, H, & K).
Thirdly, other columns (such as B, C, E, G, I, & J) have numbers, as well as
some text and blanks.
There is no problem adding the numbers to obtain the numerator
(=A1+D1+F1+H1+K1) but I'm having a problem obtaining the denominator
(counting the number of row-numeric-values) to get the average. Please
help!!

Thanks in Advance
 
Alan Cocks said:
GBL

The simple answer is

=AVERAGE(A3,D3,F3,H3,K3)
Click to expand...
Or if you want to eliminate the error message when there is no result:

=IF(ISERR(AVERAGE(A13,D13,F13,H13,K13)),"",AVERAGE(A13,D13,F13,H13,K13))
 
Hi Alan:

Thank you very much!!

Alan Cocks said:
Or if you want to eliminate the error message when there is no result:

=IF(ISERR(AVERAGE(A13,D13,F13,H13,K13)),"",AVERAGE(A13,D13,F13,H13,K13))
Click to expand...
 
Back
Top