How to Total Columns in Google Sheets
Ғылым және технология
Learn the different ways to total columns of numbers in your spreadsheet. We will discuss using the + sign and also using the SUM function. Both work, but they work in different ways.
See here for more information on the SUM function: sheetshelp.com/sum/
🕒 Timestamps:
0:00 Intro
0:37 Make it Look Nice!
1:09 Basic Method (+ operator)
2:28 Error when Using "+" Sign
2:41 SUM Function
Learn more from Prolific Oaktree:
🌳 Next Video - Google Sheets - Prevent Duplicate Entries - • Google Sheets - Preven...
🌳 Related Playlist - Google Apps | Full Tutorials - bit.ly/google-tutorials
#googlesheets #SUMfunction #prolificoaktree
Пікірлер: 70
BRILLIANT! Thanks Prolific Oaktree! 30 years of not knowing this has just been erased in 4 mins 59 secs. :)
Well done! If I can understand this, then it is really well done!
Thank you! This was exactly what I needed
Thanks very much, made this super easy to follow!
@ProlificOaktree
4 жыл бұрын
Awesome, that's what I had hoped.
Thank you so much!
This was very helpful, do you have a video that explains how if one column has sums and the next column shows the subtotal for each date? thank you
@ProlificOaktree
2 жыл бұрын
I was looking through some old comments and saw this one. It's a great question and I think I'll make a video on it. Basically though, use SUMIF or a Pivot Table. More to come...
Thank you soooooo much!!!
Thank you very much good sir!
Super helpful!
Thank you for sharing
T H A N K Y O U!!!!!! Bless your heart, I finally got it!
Hi can you total from different pages of the same spread sheet?
Thank you
i have a do where it would help if i could take for example in the video E9-C9 and would need the sum placed at F9 is that possible? i cant figure this out and i dont know if its due to E9/C9 being like equation cells or what. if someone could help or just tell me i cant do this so i can stop look that would be appreciated!
Thank you!!!
VERY HELPFUL THANK YOU
@ProlificOaktree
8 ай бұрын
You're welcome!
TY TY TY!! U made this EASY!
@ProlificOaktree
4 жыл бұрын
YW!
Hey Gracias!!! Save me a LOT of time
@ProlificOaktree
3 жыл бұрын
You're welcome!
Thanks man!
@ProlificOaktree
3 жыл бұрын
You bet!
Is there a way to set it to where it automatically adds up all the values in the cells above the total in the same row; so that way you can add more horizontal rows without having to readjust the code for the total? Thanks!
@ProlificOaktree
3 жыл бұрын
If you use the insert row function in the middle of the range that you're adding, the range will expand in your formula. Another thing you could do is put the sum function one column to the right and just make the range extend down the entire column such as =SUM(A1:A). There's no stopping point on that range so it adds all of column A.
@SpongeSebastian
3 жыл бұрын
@@ProlificOaktree Big thank you!
I am looking for an answer, hope you can help. On Excel, if you want to extend the range of cells that a formula relates to, you double click the cell that contains the formula, it shows you the outline of the cells in the range, then you simply click and drag the outline to extend the cells in the range. I.e. you can add another cell that was missed. Sheets doesn't seem to let you click and drag the outline, instead I can only change the range by typing the cell number into the formula to include it. Surely there is a click and drag functionality for this rather than typing? Can you help? Rose
@ProlificOaktree
3 жыл бұрын
Yeah, I think you've gotta re-highlight the whole range.
In the world of having to track crypto rewards.... this review of google sheets is marvelous. I am anticipating the worst case scenario that I have to manually track each action in the crypto space.
Hi! I just can´t add the numbers on the same column, it keeps me giving 0 as a result, and Im using the exact same formula. Also, other columns can be added with no problem, but the one that Im trying to is just giving me 0, what can I do?
@ProlificOaktree
3 жыл бұрын
They're probably not being recognized as numbers. Run the ISNUMBER function on them. See here support.google.com/docs/answer/3093296?hl=en
Great video but what about when you have rows continually being added and don't want redo the formula each time? A running sum for all rows
@ProlificOaktree
2 жыл бұрын
I depends how your Sheet is laid out. You can add the SUM formula to the top and use a range like A2:A. That would select everything starting A2 and below.
@Panty_Dropper_
2 жыл бұрын
@@ProlificOaktree Thanks. I have my business credit card gateway auto add rows to a google sheet through a flow and have never been able to figure out how to keep a running total without having to reformulate it each time. Another issue is that it always adds a row to the very next row even if it is the footer therefore making the latest transaction be the footer where I'd have the running totals displayed. Thanks for the response! Great tutorials!
Hey there! I'm having trouble totaling a column, when i go to total it, or sum it up, it always puts the sum with a $ in front, how can i fix this?
@ProlificOaktree
3 жыл бұрын
Select the cell that you want to change, go to Format, then Number. Choose what you want from there. The $ sign is not part of the result, it's just the format applied to it.
how do I keep a running total of a column if I update it every day? I do food shopping daily and I keep putting a new total in which changes the end cell of a formula so I have to change the formula every day which is a pain. Thanks for helping...
@ProlificOaktree
3 жыл бұрын
See how it's done in this video kzread.info/dash/bejne/lJedl7igqtPRZ8Y.html
Hi, Hope u all are safe from Corona. Lets explain my problem. I have two column A & B. I want sum like increasing A. For example, B2 is the sum of A2, B3 is the sum of A2:A3 & B4 is the sum of A2:A4. Waiting for a solution. Thanx in advance.
@ProlificOaktree
4 жыл бұрын
Maybe use the running total formula here: kzread.info/dash/bejne/lJedl7igqtPRZ8Y.html
Great video but whenever I try adding cells together it outputs what I wrote for the formula instead of the result of it. Any way to fix this?
@ProlificOaktree
3 жыл бұрын
Make sure you start with an equals sign.
@Artify.3D
3 жыл бұрын
TURN OFF "SHOW FORMULA" FROM "VIEW" TOOLBAR
How can I find the instructions to do this on Google sheets for Android
@ProlificOaktree
4 жыл бұрын
Does this help? kzread.info/dash/bejne/fol2xMarddubo84.html
I discovered I have to put "sum=" and then (c2:c8) for it to work
Anyone know how to make it show me the sum of my values instead of the formula
@ProlificOaktree
2 жыл бұрын
Maybe you left the = sign out of your formula. If it's still not working, perhaps your numbers are really text. Check them with the ISNUMBER() function.
I am doing the steps on here but it is not showing the total. Please help.
@ProlificOaktree
3 жыл бұрын
Check for spaces in your numbers. That would make the spreadsheet think they are text.
I want to sum up multiple rows going across, everytime I try, it jumbles up everything
@ProlificOaktree
3 жыл бұрын
What's the formula you are using?
A little long to get to the point but thanks for the info.
Starts at 1:10 actually doing what the video says it will.
i got a #REF! what do i do?
@ProlificOaktree
3 жыл бұрын
I'll see you in that other video);
Skip to 3:00
I don't have a computer I do it on my cellphone and is not adding up my columns 😒
@ProlificOaktree
3 жыл бұрын
It will work if you just type the formula in =SUM(A1:A3) and change the A1 and A3 with whatever the bounds of your data are.
I cant add like that it won't add ☹🙁
@ProlificOaktree
3 жыл бұрын
Try the ISNUMBER() function. Maybe you're trying to add text.
What is cell c5 lol
@ProlificOaktree
3 жыл бұрын
Oh boy...
GET TO THE POINT MAN
Thank you
Thank you so much!
@ProlificOaktree
4 ай бұрын
You're welcome!
Thank you