A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Office » General Discussions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Sum of only selected cells in Excel



 
 
Thread Tools Display Modes
  #1  
Old May 12th, 2010, 05:34 PM posted to microsoft.public.office.misc
S1L1Y1
external usenet poster
 
Posts: 141
Default Sum of only selected cells in Excel

I have Office Xp. When using Excel is there a way to get a sum of only
selected cells not in a sequence, and how can I selected those rows or
cells?
Sol


  #2  
Old May 12th, 2010, 06:45 PM posted to microsoft.public.office.misc
Bob I
external usenet poster
 
Posts: 10,698
Default Sum of only selected cells in Excel

Sum will appear in the Status bar if you enable it. And select random
cells by holding down CTRL key and clicking on them

S1L1Y1 wrote:
I have Office Xp. When using Excel is there a way to get a sum of only
selected cells not in a sequence, and how can I selected those rows or
cells?
Sol



  #3  
Old May 12th, 2010, 09:45 PM posted to microsoft.public.office.misc
ANONYMOUS[_4_]
external usenet poster
 
Posts: 28
Default Sum of only selected cells in Excel

S1L1Y1 wrote:
I have Office Xp. When using Excel is there a way to get a sum of only
selected cells not in a sequence, and how can I selected those rows or
cells?
Sol



You need to use SUMIF() formula. For example your numbers are in cells:
C1:C10. So in Cells B1:b10 enter 1 to indicate the selected cells you
want for addition purposes. Then your formula in E11 might look
something like this:

=SUMIF(B1:B10,"=1",C1:C10)

The above formula says that if cells in B1:B10 are equal to 1, then add
all corresponding cells in C1:C10

hth
 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:56 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.