| | |
MS Excel Formula Prob
![]() |
•
•
Join Date: Apr 2008
Posts: 3
Reputation:
Solved Threads: 0
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
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
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.
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)
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)
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
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.
![]() |
Other Threads in the Windows NT / 2000 / XP Forum
- Previous Thread: reformat HD with no OS disc
- Next Thread: redirusr command
| Thread Tools | Search this Thread |
.net 2007 2010 a.exe address alaris apache appstore arm auto automatically black blue book boot bulletin cellphones chkdsk collaboration computer computerfreezes crash cursor deployment desktop desktops dns dotnetnuke drive eartlink error errors explorer features folder fontmanagers format framework gadgets install intel internet interoperability killprocess laptop linux load login mac memory microsoft monitor motionle1600 netbooks novell nvidia open operatingsystems osx palm partition patch port printer product proxy remotedesktop remotedesktopconnection repair replacingraiddrive retrieve screen sharepoint simplifiedchinese sitetositevpn sp1 technology ubuntu unreadable update usb verizon videodrivers videogames virus vista visual vulnerability wab webos weecam win win32/heur windows windows7 windowsxp windowsxpnotstartingup. worm xp xpde






