@ReadySteadyExcel
Really good video - deserves more views! I came across your channel when doing research on a different topic for my own channel. The layout of your website is good too.
@biodunwilliams8752
Thank you for your video
@ARescueToaster
Thanks for the video and help - it's greatly appreciated! Is it impractical to have the sum BEFORE the columns of data rather than after? Auto sum doesn't appear to work like that, so I've resorted to setting a name for a range in the columns (IE: I select A3 through A200, name that selection "AColumn" and then, while in A2, I write in the function =SUM(AColumn) It works but I feel there has to be an easier method than that! I'm also worried that in a year or two, when I get to A201 I'll start running into issues with incorrect totals and by then I'll have forgotten what I did 2 years prior
@lordgod4300
Chris, you stated that you wouldn’t set up your file file this way. How would you set up your data? What’s the best way. I have a similar set of data that I want to analyze.
@ghostriders_1
At the moment when I select a series of numbers to auto sum they all change into the number in the top cell? Help!
@shelbygallegos5963
Is there a way to make an automatic scoreboard? Example, like to have names on row 1 per column. And per name column as example, I would type entry in A2 score of 100, the another entry in A3 100 and auto sum for A4 populate 200 automatic. Entry for A5 and auto sum automatically in A6.
@johnbenedicts.santos760
hi im a student but i have a question how do you not go through the lines of the other cells?
@soumiamoujane3695
What's the formula for totalling up Yearly shopping. Can I use autosum to total up a shopping list for the whole year?. For example can I type =SUM(D6:Z38 in Total box and click enter. And for monthly total do I use autosum by typing =( SUM(Z6:D38 in the total box and click enter
@TheodoreNozart
Wow!!
@luckypapi87
How do you use autosum automatically?
@93gmc666
Why does it just have ####### when I hit the auto sum?
@arasaratnamelangovan8400
it works on mac
@britishagent