Sum across sheets based on a condition
Let's take the easy way on this!
On *each* sheet, in the same cell enter this formula:
=(B1=1)*SUM(A1:A10)
You can group the sheets together and enter the formula on one sheet and it
will be entered on *all grouped* sheets.
Let's assume you enter that formula on each sheet in cell A11. Then:
=SUM(Sheet1:Sheet40!A11)
--
Biff
Microsoft Excel MVP
"GoBow777" wrote in message
...
Hello; I'm trying to sum cells A1:A10 across several sheets no problem.
However, if cell B1 on each of the sheets does not equal the value of 1
found on the Summary sheet, then those sheets would not be added.
In other words if Sheet3 cell B1 has a value of 2, then Sheet3 would
not be included in the summing process, but Sheet2, Sheet4 through
Sheet40 would be.
Keep in mind that the range A1:A10 has to show their values regardless
of the value of cell B1.
How can this be done?
--
GoBow777
|