sum columns form each sheets to one column in Main sheet

[kared]

Hi,
I would like in the sheet "Main" to sum in one column the individual rows F258:F757 from all sheets in the workbook except Main. For example, if in sheet1 in column F258 = 1, sheet2 in column F258 = 0, sheet3 in column F258 = 1, the sum from all cells F258 appeared in arukusz Main in position B2 and so with each row.

I thought I could do it this way:



=SUMA(ZUE!F258;ZEP!F757)


where ZUE and ZEP is a name sheets, but i have more worksheets in workbook. I don't know how instead of typing the name of each sheet, to do it for all of them.

[kared]

My second sheet after Main is ZUE and last is ABE. i try =SUM(ZUE:ABE!F258), but it not work.

[Aussiebear]

Normally the formula would look like Sum('First Sheet: Last Sheet'! Cell to be summed)

[kared]

For example, i creat new workbook with 4 sheets.
Sheet1 is where i put formul.

i write in cell A1 in sheet2, sheet3, sheet4 value 1.

Formula which i should use to sum is

=SUM(sheet2:sheet4!A1) ?

[Aussiebear]

=SUM(sheet2:sheet4!A1) ?

You are missing the single quotation marks

=Sum('Sheet2:Sheet4'!A1)