Hi,
I am trying to do summation of a function in excel. The function I am trying to write is
12.5+$J$1*sin($C$5*C8)+$J$2*sin($C$5*C8)+$J$3*sin($C$5*C8)...$J$128*sin($C$5*C8)
without having to write out all the terms
I currently have it written like this 12.5+sum(row($J$1:$J$128)*sin($C$5*C8)) however this is giving incorrect results. What am i doing wrong?
Thanks,
Nick
Bookmarks