LinkBack URL
About LinkBacks
Is there a way to sum for formulas.
I want to sum the formula shown in the screenshot.
I know it can be done using another row to calculate, and then using a simple SUM, but wanted to know if it was possible to have formulas inside SUM.
Capture.PNG
Is there a way to sum for formulas.
I want to sum the formula shown in the screenshot.
I know it can be done using another row to calculate, and then using a simple SUM, but wanted to know if it was possible to have formulas inside SUM.
Capture.PNG
Last edited by Un-Do Re-Do; 12-01-2020 at 06:28 AM.
You don't make it clear whether you want to do that for individual pairs of x and y or for all of them in one formula, but you can use this in H1 for the first pair:
=SUM(2*B1,B2^2)
then copy across as required.
Hope this helps.
Pete
Thanks for the quick response.
It is for all of them, and without copying across, so just in one cell.
Then this:
=SUM(2*(B1:F1)+(B2:F2)^2)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
That actually gives an error. #VALUE! is the result.
You can use this array* formula:
=SUM(2*B1:F1,B2:F2^2)
*Note that an array formula needs to be confirmed using the key combination of Ctrl-Shift-Enter (CSE) instead of the usual Enter.
Hope this helps.
Pete
Apols. I forgot to mention that it's an array formula.
Wow, it actually works.
Thanks to both for the answer.
Of course they work !!
Glad to help, and thanks for the rep.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks