Summing the results of a formula on a series of data

[linmed01]

Is there a way to SUM the result of the followig for B4:J4 and B16:J16, the other cell references remain static:

=(B28*(P28^2-IF(ISNUMBER(B16),ABS(B4-B16)^2,B31)))

I a currently using the following which is rather lengthy and not efficient to maintain/edit:

=(B28*(P28^2-ABS(B4-B16)^2))+(B28*(P28^2-ABS(C4-C16)^2))+(B28*(P28^2-ABS(D4-D16)^2))+(B28*(P28^2-ABS(E4-E16)^2))+(B28*(P28^2-ABS(F4-F16)^2))+(B28*(P28^2-ABS(G4-G16)^2))+(B28*(P28^2-ABS(H4-H16)^2))+(B28*(P28^2-ABS(I4-I16)^2))+(B28*(P28^2-ABS(J4-J16)^2))

Any help would be greatly apreciate as I'm at the limit of my Excel knowledge!

Many thanks!

 

[Gerald Higgins]

Hi, welcome to the board. I'm not a statistician, but it looks like that may be an attempt to replicate some recognised statistical function, is that right ?
If yes, there may be an Excel function that does that for you.

 

[linmed01]

Hi, thanks for the reply, to be honest I'm representing someone elses formula in Excel, and although I know what it does I'm not sure the exact definition for what it does. So basically if there was a function in Excel to do this for me, I wouldn't know it if it jumped out and bit me!