Google Sheeets: SUM of SUM of cells in a row, divided by another cell in the same row

Antonescu

New Member
Joined
Feb 19, 2021
Messages
21
Office Version
  1. 365
Platform
  1. Windows
Hi guys,

Sorry if this was asked before.
I am trying to make the total SUM of cells in a ROW, DIVIDED by another cell in the same ROW.
Like below, but without having to add them row by row.
1648047396245.png

Thanks a lot!
 
Last edited by a moderator:

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
How about
Excel Formula:
=SUM(A2:C4/D2:D4)
 
Upvote 0
Solution
It worked with =sumPRODUCT(A2:C4/D2:D4) instead of SUM
Thank you very much for the idea :)
 
Upvote 0
If you are using xl 365 then it should work with SUM. Is your profile correct?
 
Upvote 0
My bad, sorry! Profile is correct, but I put this one in Google sheets.
Thanks again, you saved me a lot of time :)
 
Upvote 0
You're welcome & thanks for the feedback.
 
Upvote 0
OK, for future reference, please note that the "Excel Questions" forum is not the proper place to ask Google Sheets questions.
Please post to the "General Discussion & Other Applications" forum, as per the description:

1648053534315.png


I have moved this thread for you and updated the question title.
 
Upvote 0

Forum statistics

Threads
1,223,964
Messages
6,175,659
Members
452,666
Latest member
AllexDee

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top