# Summing the results of a formula on a series of data

#### linmed01

##### New Member
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!

### Excel Facts

Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
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.

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!

Replies
6
Views
234
Replies
2
Views
595
Replies
6
Views
289
Replies
3
Views
247
Replies
3
Views
150

1,203,502
Messages
6,055,777
Members
444,823
Latest member
AnAverageGuy

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back