Data Sum

[sohaibj]

I've data in following cells on 50 sheets of a file

B7:D21

how can I consolidate them on First sheet from B7:D21

 

[GlennUK]

Do you mean that you want this in B7 of the First sheet:

=SUM(Sheet2:Sheet51!B7)

?

 

[sohaibj]

Its not working.
Let me elaborate my question again.

I've Production data in cell, let suppose C7 of the following sheets. These sheets are renamed as follows and they are more than 50 sheets:
June-28
June-29
June-30
.......... etc
How can I sum C7 cell of all these sheets on let say Main sheet?

 

[markmzz]

Maybe this:

Note: look at the ' in the formula.

=SUM('June-28:June-30'!C7)

<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>C</th><th>D</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">7</td><td style="text-align: center;;">870</td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="text-align: center;;">*****</td><td style="text-align: center;;">*****</td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Master</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C7</th><td style="text-align:left">=SUM(<font color="Blue">'June-28:June-30'!C7</font>)</td></tr></tbody></table></td></tr></table><br />
Markmzz

 

[MrVillareal]

Its not working.
Let me elaborate my question again.

I've Production data in cell, let suppose C7 of the following sheets. These sheets are renamed as follows and they are more than 50 sheets:
June-28
June-29
June-30
.......... etc
How can I sum C7 cell of all these sheets on let say Main sheet?

Hi

In your main sheet(SHEET1).
Type in cell A1 =SUM('SHEET2:SHEET52!C7).

But with regard to your original question I suggest you use "Consolidate" under the Data Tab. Especially if you have Column and Row Field.

 

[MrVillareal]

However if you are just simply adding all values of B7:D21, then simply use this:

Any cell in main sheet(Sheet1) type =SUM('Sheet2:Sheet52'!B7:D21)

Hope this add help to you.