MS Excel Formula Prob

Reply

Join Date: Apr 2008
Posts: 3
Reputation: Ajitbmsce is an unknown quantity at this point 
Solved Threads: 0
Ajitbmsce Ajitbmsce is offline Offline
Newbie Poster

MS Excel Formula Prob

 
0
  #1
Feb 16th, 2009
I want to add some different col.no. according to my requirement but Sum () is it taking only 30 individual no. (or 30 parameter) after that it is showing too many paramters
How to add more than 30 individual no. in EXCEL

it's a big prb for me
Reply soon
Reply With Quote Quick reply to this message  
Join Date: Apr 2007
Posts: 1,104
Reputation: cguan_77 has a little shameless behaviour in the past 
Solved Threads: 91
cguan_77's Avatar
cguan_77 cguan_77 is offline Offline
Veteran Poster

Re: MS Excel Formula Prob

 
0
  #2
Feb 16th, 2009
post your question at software development...visual basic..

anyway what you really want to do add columns, rows or what..

can you attach the file that you're trying to do..
Reply With Quote Quick reply to this message  
Join Date: Apr 2008
Posts: 3
Reputation: Ajitbmsce is an unknown quantity at this point 
Solved Threads: 0
Ajitbmsce Ajitbmsce is offline Offline
Newbie Poster

Re: MS Excel Formula Prob

 
0
  #3
Feb 16th, 2009
No, i just want to find sum of more than 30 cell in a particular row or column.

suppose i am having 100 row data. Here i want to calculate the sum of only 40 row that is not necessary in continuous range but in scattered row no.
For ex. c1, c5,c11,c13,15,c23,c24,c25,c27,..... forty cell.
i am using formula =Sum(c1,c5,c11,c13,c15,c23,...........) for this.

then it is showing too many parameters but it is accepting till 30 parameter
Reply With Quote Quick reply to this message  
Join Date: Aug 2007
Posts: 1,729
Reputation: Suspishio is an unknown quantity at this point 
Solved Threads: 137
Sponsor
Suspishio's Avatar
Suspishio Suspishio is offline Offline
Simples!

Re: MS Excel Formula Prob

 
0
  #4
Feb 16th, 2009
Excel 2007 has increased this limit from 30 to 255 items in your argument list.

No way of doing it directly with your version of excel.
Suspishio
My advice is at your risk
Qosmio G50-10H; T9400 2.53GHz Core 2 Duo; 4GB RAM; Vista HP (32)
nForce 680i LT; Q6600 Quad Core 2.4GHz; 8GB RAM; XP Pro (64)
Dell XPS M1710; T7200 2GHz Core 2 Duo; 2GB RAM; XP Pro (32)
Reply With Quote Quick reply to this message  
Join Date: Apr 2007
Posts: 1,104
Reputation: cguan_77 has a little shameless behaviour in the past 
Solved Threads: 91
cguan_77's Avatar
cguan_77 cguan_77 is offline Offline
Veteran Poster

Re: MS Excel Formula Prob

 
0
  #5
Feb 17th, 2009
hi ajitbmcse, try this macro.. go to tools -> macro then create a new macro..i tested it up to 50 cells its working.. don't put a double space between each data cell like c1 c2..make sure only one space between them or else there will be an error

here's the code
Sub TotalValue()
    Dim strcells, strsum As String
    Dim Splitval As Variant
    Dim intIndex, totalval As Integer
    Dim cellvalue, strsplit As String
    
strcells = InputBox("Enter the cells you want to be added, enter with spaces like: c1 c2 c10")

strsum = InputBox("Enter the cell where you want to display the total value, enter like: F1")



    Splitval = Split(strcells, " ")
    For intIndex = LBound(Splitval) To UBound(Splitval)
         
       strsplit = Splitval(intIndex)
       cellvalue = Range(strsplit).Value
       totalval = cellvalue + totalval
       Range(strsum).Value = totalval
       
    Next
End Sub

Last edited by cguan_77; Feb 17th, 2009 at 6:20 am.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Other Threads in the Windows NT / 2000 / XP Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC