Simplifying a formula

[carlleese24]

Hi

Any help on this would be greatful

does anyone know of a simple way in which to do this formula.

=(ABS(H7-G7)+ABS(H7-G6)+ABS(H7-G5)+ABS(H7-G4)+ABS(H7-G3))/5

 

[Richard Schollar]

Hi

Here's one wy:

Excel Workbook
	G	H	I	J
3	9
4	15
5	16
6	3
7	2	10		5.4
Sheet2

Excel 2010

Cell Formulas
Range	Formula
J7	=SUMPRODUCT(ABS(H7-G3:G7))/5

 

[carlleese24]

thankyou it works brilliantly