kared
05-21-2022, 04:04 PM
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.
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.