Hello every body, I'm trying to make a funtion to place in my Add In's to
save space in my actual workbook.
what I'm trying to do, it's something like this
:=IF(G10,(IF(J1=7,((SUM(A2:A7)+J1)/I1),SUM(A2:A6)+J1)/I1))),(IF(J1=7,(SUM(A2:A7)/I1),(SUM(A2:A6)I1)))).
where G=F-H,for each row.
can enyone plz. help me with this.

I J
325 6

A B C D E
F G H
75 75 40 37 76 76 1 7.70
500 575 216 404 620 696 121 7.30
900 1475 435 430 865 1561 86 5.34
500 1975 353 306 659 2220 245 5.22
300 2275 125 127 252 2472 197 4.92
150 2425 148 73 220 2693 268 5.28
150 2575 113 118 231 2924 349 5.30
250 2825 186 80 266 3190 365 4.58
300 3125 133 162 295 3485 360 3.65
300 3425 199 111 310 3795 370 2.75
250 3675 157 72 229 4023 348 1.92
200 3875 84 53 137 4161 286 1.11
75 3950 58 0 58 4218 268 None
3950 11 0 11 4229 279 now!