Sum across sheets based on a condition

G

GoBow777

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?
 
T

T. Valko

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)
 
G

GoBow777

Thanks Biff!

I was hoping for a single formula but this does the job just fine.

Mat
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function for summing or counting cells based on a specified fill color 2
Variable reference in a function 3
Vary sheet name & sum across multiple sheets 3
Using SUM & VLOOKUP together?? 1
Trying to SUM variable number of VLOOKUPs 7
SUM function over infinite number of sheets? 1
Vlookup with multiple FOR condition 1
Conditional Formatting across Sheets 5

Top