addition of the values in the cells

gopalakrishnarao1

Board Regular
Joined
Nov 23, 2008
Messages
146
I AM HAVING DATA OF 210 BRANCHES OF DIFFERENT ITEMS. EACH BRANCH HAS AROUND 100 TO 150 ITEMS. I WANT TO ADD THE VALUES OF EACH BRANCH AND I HAVE TO GET THE GRAND TOTAL VALUE IN A SINGLE SHEET. SUPPOSE IF ADD E10+E210+E350+E470 LIKE THIS AFTER SOME pLUSES I WILL GET THE FORMULA RANGE IS OVER. IS THERE ANY METHOD OF ADDING 210 BRANCHES ITEMS
EXPERTS, PROFESSIONALS, GENIUS PERSONS PLEASE HELP
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
I AM HEREWITH ATTACHING THE FILE FOR YOUR INFORMATION.
worksheet


<TABLE style="PADDING-RIGHT: 2pt; PADDING-LEFT: 2pt; FONT-SIZE: 10pt; FONT-FAMILY: Arial,Arial; BACKGROUND-COLOR: #ffffff" cellSpacing=0 cellPadding=0 border=1><COLGROUP><COL style="FONT-WEIGHT: bold; WIDTH: 30px"><COL style="WIDTH: 27px"><COL style="WIDTH: 95px"><COL style="WIDTH: 67px"><COL style="WIDTH: 241px"><COL style="WIDTH: 121px"><COL style="WIDTH: 31px"><COL style="WIDTH: 112px"></COLGROUP><TBODY><TR style="FONT-WEIGHT: bold; FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17789</TD><TD style="TEXT-ALIGN: right">1</TD><TD style="TEXT-ALIGN: right">4354</TD><TD style="TEXT-ALIGN: right">4354</TD><TD>RACKS STEEL(121)</TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">638</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17790</TD><TD style="TEXT-ALIGN: right">2</TD><TD style="TEXT-ALIGN: right">4355</TD><TD style="TEXT-ALIGN: right">4355</TD><TD>CABINET FIRE PROOF STEEL(2</TD><TD>1)</TD><TD></TD><TD style="TEXT-ALIGN: right">3084.51</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17791</TD><TD style="TEXT-ALIGN: right">3</TD><TD style="TEXT-ALIGN: right">4356</TD><TD style="TEXT-ALIGN: right">4356</TD><TD>SAFE(128)</TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">21300</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17792</TD><TD style="TEXT-ALIGN: right">4</TD><TD style="TEXT-ALIGN: right">4357</TD><TD style="TEXT-ALIGN: right">4357</TD><TD>CUP BOARD STEEL(51)</TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">4888</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17793</TD><TD style="TEXT-ALIGN: right">5</TD><TD style="TEXT-ALIGN: right">4358</TD><TD style="TEXT-ALIGN: right">4358</TD><TD>CHAIR FOLDING STEEL(32)</TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">160</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17794</TD><TD style="TEXT-ALIGN: right">6</TD><TD style="TEXT-ALIGN: right">4359</TD><TD style="TEXT-ALIGN: right">4359</TD><TD>CHAIR FOLDING STEEL(32)</TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">140</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17795</TD><TD style="TEXT-ALIGN: right">7</TD><TD style="TEXT-ALIGN: right">4360</TD><TD style="TEXT-ALIGN: right">4360</TD><TD>CHAIR WITH ARMS STEEL(30)</TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">743.08</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17796</TD><TD style="TEXT-ALIGN: right">8</TD><TD style="TEXT-ALIGN: right">4361</TD><TD style="TEXT-ALIGN: right">4361</TD><TD>CHAIR STEEL(36)</TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">335.4</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17797</TD><TD style="TEXT-ALIGN: right">9</TD><TD style="TEXT-ALIGN: right">4362</TD><TD style="TEXT-ALIGN: right">4362</TD><TD>EMBEDDING TO EXISTING SAFE</TD><TD style="TEXT-ALIGN: right">-125</TD><TD></TD><TD style="TEXT-ALIGN: right">25346</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17798</TD><TD style="TEXT-ALIGN: right">10</TD><TD>. 4363</TD><TD style="TEXT-ALIGN: right">4363</TD><TD>NAME BOARD -WOODEN(103)</TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">456</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17799</TD><TD style="TEXT-ALIGN: right">11</TD><TD>. 4364</TD><TD style="TEXT-ALIGN: right">4364</TD><TD>OFFICER'S TABLE WOOD(109)</TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">975</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17800</TD><TD style="TEXT-ALIGN: right">12</TD><TD>. 4365</TD><TD style="TEXT-ALIGN: right">4365</TD><TD>CHAIRS - WOODEN(37)</TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">304</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17801</TD><TD style="TEXT-ALIGN: right">13</TD><TD>. 4366</TD><TD style="TEXT-ALIGN: right">4366</TD><TD>CLERICAL TABLE WOODEN(41)</TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">650</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17802</TD><TD style="TEXT-ALIGN: right">14</TD><TD>. 4367</TD><TD style="TEXT-ALIGN: right">4367</TD><TD>SIDE TABLE WOOD(127)</TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">255</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17803</TD><TD style="TEXT-ALIGN: right">15</TD><TD>. 4368</TD><TD style="TEXT-ALIGN: right">4368</TD><TD>WORKING HOURS BOARD WOOD(1</TD><TD>67)</TD><TD></TD><TD style="TEXT-ALIGN: right">80</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17804</TD><TD style="TEXT-ALIGN: right">16</TD><TD>. 4369</TD><TD style="TEXT-ALIGN: right">4369</TD><TD>TRAYS WOODEN(157)</TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">65</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17805</TD><TD style="TEXT-ALIGN: right">17</TD><TD>. 4370</TD><TD style="TEXT-ALIGN: right">4370</TD><TD>CASHCOUNTER WOOD(27)</TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">1490</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17806</TD><TD style="TEXT-ALIGN: right">18</TD><TD>. 4371</TD><TD style="TEXT-ALIGN: right">4371</TD><TD>BACK BENCH WOOD(5)</TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">445</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17807</TD><TD style="TEXT-ALIGN: right">19</TD><TD>. 4372</TD><TD style="TEXT-ALIGN: right">4372</TD><TD>NOTICE BOARD WOOD(101)</TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">125</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17808</TD><TD style="TEXT-ALIGN: right">20</TD><TD>. 4373</TD><TD style="TEXT-ALIGN: right">4373</TD><TD>OFFICER'S TABLE WOOD(109)</TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">975</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17809</TD><TD style="TEXT-ALIGN: right">21</TD><TD>. 4374</TD><TD style="TEXT-ALIGN: right">4374</TD><TD>COUNTER WOODEN(48)</TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">4840</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17810</TD><TD style="TEXT-ALIGN: right">22</TD><TD>. 4375</TD><TD style="TEXT-ALIGN: right">4375</TD><TD>GOLD WEIGHING SCALE(129)</TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">326.48</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17811</TD><TD style="TEXT-ALIGN: right">23</TD><TD>. 4376</TD><TD style="TEXT-ALIGN: right">4376</TD><TD>WALLCLOCK(162)</TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">186.4</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17812</TD><TD style="TEXT-ALIGN: right">24</TD><TD>. 4377</TD><TD style="TEXT-ALIGN: right">4377</TD><TD>FANS CEILINGS FANS ELEC(73</TD><TD>)</TD><TD></TD><TD style="TEXT-ALIGN: right">450</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17813</TD><TD style="TEXT-ALIGN: right">25</TD><TD>. 4378</TD><TD style="TEXT-ALIGN: right">4378</TD><TD>ALARM SECURITY ALARM(2)</TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">6800</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17814</TD><TD style="TEXT-ALIGN: right">26</TD><TD>. 4379</TD><TD style="TEXT-ALIGN: right">4379</TD><TD>Bicycle(8)</TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">527</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17815</TD><TD style="TEXT-ALIGN: right">27</TD><TD>. 4380</TD><TD style="TEXT-ALIGN: right">4380</TD><TD>CHAIR PLASTIC WOOD(33)</TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">259</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17816</TD><TD style="TEXT-ALIGN: right">28</TD><TD>. 7412</TD><TD style="TEXT-ALIGN: right">7412</TD><TD>NOTE COUNTING/FND MACHINE(</TD><TD>102)</TD><TD></TD><TD style="TEXT-ALIGN: right">9000</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17817</TD><TD style="TEXT-ALIGN: right">29</TD><TD>. 8197</TD><TD style="TEXT-ALIGN: right">4359</TD><TD>CHAIR FOLDING STEEL(32)</TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">140</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17818</TD><TD style="TEXT-ALIGN: right">30</TD><TD>. 8198</TD><TD style="TEXT-ALIGN: right">4371</TD><TD>BACK BENCH WOOD(5)</TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">445</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17819</TD><TD style="TEXT-ALIGN: right">31</TD><TD>. 9007</TD><TD style="TEXT-ALIGN: right">4380</TD><TD>CHAIR PLASTIC WOOD(33)</TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">259</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17820</TD><TD style="TEXT-ALIGN: right">32</TD><TD>. 9233</TD><TD style="TEXT-ALIGN: right">4380</TD><TD>CHAIR PLASTIC WOOD(33)</TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">259</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17821</TD><TD style="TEXT-ALIGN: right">33</TD><TD>. 9599</TD><TD style="TEXT-ALIGN: right">4369</TD><TD>TRAYS WOODEN(157)</TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">65</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17822</TD><TD style="TEXT-ALIGN: right">34</TD><TD>. 9990</TD><TD style="TEXT-ALIGN: right">4369</TD><TD>TRAYS WOODEN(157)</TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">65</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17823</TD><TD style="TEXT-ALIGN: right">35</TD><TD>. 10381</TD><TD style="TEXT-ALIGN: right">4369</TD><TD>TRAYS WOODEN(157)</TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">65</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17824</TD><TD style="TEXT-ALIGN: right">36</TD><TD>. 19116</TD><TD style="TEXT-ALIGN: right">7413</TD><TD>PC-HP(1035)</TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">23000</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17825</TD><TD style="TEXT-ALIGN: right">37</TD><TD>. 19117</TD><TD style="TEXT-ALIGN: right">7414</TD><TD>DOT MATRIX-EPSON(1014)</TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">11400</TD></TR><TR style="HEIGHT: 17px"><TD style="FONT-SIZE: 8pt; BACKGROUND-COLOR: #cacaca; TEXT-ALIGN: center">17826</TD><TD style="TEXT-ALIGN: right">38</TD><TD>. 19118</TD><TD style="TEXT-ALIGN: right">7415</TD><TD>UPS-TECHSER(1002)</TD><TD></TD><TD></TD><TD style="TEXT-ALIGN: right">9500</TD></TR></TBODY></TABLE>
LIKE THIS I AM HAVING THE DATA OF 210 BRANCHES, EACH BRANCH HAS MANY ITEMS.
PLEASE HELP

Excel tables to the web >> Excel Jeanie HTML 4
 
Last edited:
Upvote 0
Again, I think Stan is right sumproduct might be the answer here, but we need a description of what you want and not in all caps.
 
Upvote 0
What I want is the value of the items which is recorded in the column, "g"
which is required to calculate the percentage of depreciation for the year ending purpose. sumproduct how to use it? where to define it? whether it is to be done in individual branchwise ?
please help.
 
Upvote 0
gopalakrishnarao1,

Can we have a screenshot of the top 30 rows of your worksheet showing titles?

And, can we have a screenshot of what your summary area will be (its setup)?


Have a great day,
Stan
 
Upvote 0
I am herewith enclosing the sample data I want the totals of values, and current values of each branch, as soon as the last item is over I want the totals, If any thing to be added like blank space for all the branches after the last item I will insert the blank row.
Please help. guide me. It serves many purpose because everyday like this many totals are to be made.
Excel Workbook
ABC
24ranch : Bilikere (2)
25
26Group NameValueCurr.Val.
27
28STEEL FURNITURE46912.8718328.00
29WOODEN FURNITURE65732.5020023.00
30ELECTRICAL INSTALLATIONS1686.00996.00
31BICYCLE650.006.00
32ELECTRONIC ITEMS10950.006366.00
33
34TOTAL125931.3745719.00
35
36
37
38ranch : Sathegala (4)
39
40Group NameValueCurr.Val.
41
42STEEL FURNITURE39426.2019538.00
43WOODEN FURNITURE73599.7443259.00
44ELECTRICAL INSTALLATIONS2815.002280.00
45BICYCLE1575.00173.00
46ELECTRONIC ITEMS9000.009000.00
Sheet1
 
Upvote 0
gopalakrishnarao1,

I would like to see the top 40 rows of your displayed sheet "worksheet" (post #3), from column A to column G.


Have a great day,
Stan
 
Upvote 0
gopalakrishnarao1,

I need to see the worksheet that displays information like "ranch : Bilikere (2)"

I would like to see the top 40 rows of data, including titles, from your displayed sheet "worksheet" (post #3), from column A to column G.


See my Private Message to you (top right hand corner of MrExcel, Welcome, gopalakrishnarao1., "Your Notifications:".


Have a great day,
Stan
 
Upvote 0

Forum statistics

Threads
1,202,901
Messages
6,052,441
Members
444,581
Latest member
naninamu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top