| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sum across sheets based on a condition
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sum If based on a 3rd condition ? | Excel Worksheet Functions | |||
| Sum based on specific condition | Excel Worksheet Functions | |||
| Referencing Across Sheets Based On Condition | Excel Worksheet Functions | |||
| populating sheets based on data from parent sheets | Excel Discussion (Misc queries) | |||
| Cannot sum values based on condition | Excel Worksheet Functions | |||
Threaded Mode
