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

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
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,358
Messages
6,171,625
Members
452,412
Latest member
thomasleysen531

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