Excel’s QuickSum Calculator – Get Results Without Writing a Function
MS Excel 2003 has a great feature – The QuickSum Calculator – but you have to know where to find it. It is on the Status Bar – that area at the lower right of your screen. Simply select at least two data cells. They can be contiguous or non-contiguous. But remember where to look for the QuickSum Calculator – it is on the Status Bar.
Want to change the function? It simple! Just right-click on the name of the Function. You can choose Average, Count, Count Numbers, Min or Max – Excel’s most common Functions.
This is a great way to perform an Ad-hoc Query. I recommend that you use this for spreadsheets with Subtotals. Watch this short video lesson to see how this works – and how you can save time!
March 14th, 2011 at 5:15 PM
Hi Danny really enjoy your tutorials and have learnt so much about excel as a result.
Can you help with the following problem? Whenever I email a worksheet with conditional formating the recipients lose the conditional formating.
Is there a way of locking in the conditional formating so that it appears in their spreadsheet? We are all using 2007.
cheers
steven
March 14th, 2011 at 6:55 PM
Hi Steven -
Thank you for your kind words. I am pleased that you have picked up some good tips for using Excel from my videos and posts. I am going to email you directly to respond to your query. I did a little bit of research on the topic and I have a few thoughts that might help you with this.
Best wishes,
Danny Rocks
April 18th, 2011 at 7:59 PM
ARRRRGHHHH , LOL
Time calculations, do you have a tutorial for a timecard using military time for in/ out with a lunch.
April 19th, 2011 at 1:29 AM
I do have a lesson in Excel that uses military time – the focus is on converting from military time to standard time (AM – PM). I also have several lessons illustrating how to structure a time card (hours worked before and after lunch). I do not have a lesson that combines BOTH. Let me see what I can come up with during the next few weeks.
Danny
May 10th, 2011 at 11:52 PM
Danny,
I am working on a spread sheet and I am trying to get a number in one cell (lets call it A1) which stays constant/starting point and have cells subtract as they are entered (lets call it B10 thru M10) from A1 and the total running be in another cell (lets call it H5)?? I am stumped!! To clarify, I want Cells B10 thru M10 to subtract as they are entered mothly from A1 and the total number show in H5… Any help would be great. I also want to thank you for your postings on You Tube as they are teachign me a lot about excel!
Thank you!
Ron
May 11th, 2011 at 12:23 AM
I figured it out!! if you had an easier way than using MAX please let me know… fun stuff!
May 11th, 2011 at 5:01 AM
Hi Ron -I am pleased that my video tutorials are helping you. And I am happy to hear that you figured out how to solve your problem.
Thank you for writing to me.
Danny Rocks
May 11th, 2011 at 5:08 AM
Hi Ron -
If I understand you correctly, the constant cell A1 needs to be referred to as $A$1 (Absolute Cell reference) when you perform your subtractions.
For a running total formula – let’s say cells B2:B25 contain the daily sales numbers that you want to total in B26. Write the formula as =SUM(B$2:B2) and copy it down. The left side of the range B$2 is the “anchor” – you will always be calculating the running total beginning with row 2 and moving down – relative reference B2 becomes B3, B4, etc.
Thanks for asking me for help.
Danny
June 25th, 2011 at 12:03 AM
hi..really good stuff !! i have a query..can we somehow using excel macros or may me other tools get data automatically from website..Basically i need to manually export around 15-20 different parameters from a website ( in csv format) and then post process (pivot tables charts looku) the using excel …so i was hoping if there is someway for doing it automatically…post processing i have been able to write macro..was wondering if there is way to automatically download the file also
June 25th, 2011 at 2:52 AM
Thank you for your comments.
Re: Gathering information from the internet. Here is a link to a video tutorial that covers this topic:
http://www.thecompanyrocks.com/create-a-web-query-in-excel-to-gather-updated-information/
I would have to have more information – the website that you wish to query, etc. in order to answer your question.
Danny Rocks
January 18th, 2012 at 6:21 PM
Hello,
I’m having problems with my excel sheet. I’m trying to re -size all of my cells at once and I can’t find a way to do it.
thanks for your help.
January 24th, 2012 at 8:05 AM
Lehi -
To re-size all Excel Cells at one time, you have 2 choices:
1) Change the ZOOM Level – From the VIEW Tab or Menu – change the Screen Magnification Up or Down. This does not affect the Font Size or how your Excel Worksheet will be printed.
2) Select ALL Cells (Use the Ctrl + A Keyboard Shortcut) and then change the FONT SIZE for all Cells. While all of the cells in the worksheet are selected, you may have to adjust the ROW Height. Do this for one row and all of the rows will adjust automatically.