HOME BZU Mail Box Online Games Radio and TV Live Cricket Score All Albums
Go Back   BZU PAGES: Find Presentations, Reports, Student's Assignments and Daily Discussion; Bahauddin Zakariya University Multan Welcome to all the Students Tutorial How to ?


Reply
 
Thread Tools Search this Thread Rate Thread Display Modes
  #1  
Old 11-04-2010, 10:27 PM
.BZU.'s Avatar


 

Join Date: Sep 2007
Location: near Govt College of Science Multan Pakistan
Posts: 9,688
Contact Number: Removed
Program / Discipline: BSIT
Class Roll Number: 07-15
.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute.BZU. has a reputation beyond repute
Smile How to take Sum in Excel (Help - Extended)


I'm sure we're all aware of Excel's handy little AutoSum button and the way it will quickly insert the formula to sum any range of data we happen to have lying around.

But… wouldn't it be nice if we could get it to do a little more than sums without a lot of extra work?

Good idea! Fortunately for all of us, AutoSum can be used for more than sums. Interested?

Yeah, I thought you might be.

The key to getting more from your AutoSum button is to notice the little down arrow just to the right of the button

Name:  autosum-right-arrow.gif
Views: 140
Size:  1.2 KB

Go ahead - give it a click.

You should find that a list of common functions is available - allowing you to use this button for more than just sums.

Name:  autosum-extra-functions.gif
Views: 150
Size:  3.1 KB

As usual, to get this to work for you simply select a cell either below or to the right of your data range.

Next click the down arrow of the AutoSum button and choose a function from the list.

Instantly, Excel will create the requested formula using the most obvious data range relative to the selected cell.

Name:  example-ave-formula.gif
Views: 182
Size:  2.3 KB

If you accept the data range selected by Excel then hit the Enter key.

If you need to adjust the data range for the formula you can use the Shift key in combination with the arrow keys to enlarge or shrink the selection size.

If you're looking to simply move the data range without adjusting its size you can use the mouse. Run the mouse pointer over the blue dotted rectangle until it becomes a 4-way arrow. Now click, hold and drag the selection to the correct location on the worksheet and release the mouse button.

And there you have it! Who knew we had an AutoSum button with talents beyond addition at our disposal the whole time?


__________________
(¯`v´¯)
`*.¸.*`

¸.*´¸.*´¨) ¸.*´¨)
(¸.*´ (¸.
Bzu Forum

Don't cry because it's over, smile because it happened
Reply With Quote
Reply

Tags
excel, extended, sum


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Great Work Excel... (Never seen b4) Raheel ETC 0 09-02-2010 06:37 PM
Excel Formulas.. Raheel Tutorial 1 24-11-2009 07:19 PM
Microsoft Excel shortcut keys Foki PC and Windows Tutorial 0 11-05-2009 12:10 AM
Excel Creation... usman_latif_ch Chit Chat 3 09-05-2009 05:30 PM

Best view in Firefox
Almuslimeen.info | Cloud Computing | Dedicated server hosting
Note: All trademarks and copyrights held by respective owners. We will take action against any copyright violation if it is proved to us.

All times are GMT +5. The time now is 04:48 PM.

Powered by vBulletin® Version 3.8.2
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.