| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula to get sum from one 31 sheets to a summary sheet.
I have figured out the formula to get the sum from 31 sheets on to a summary
sheet at the end of the Excel book; EX: =SUM(1:31!J3:J8). However, I now need to know how to do it with an exception. Ex: I need =SUM(1:31!P3:P4) BUT ONLY IF J3:J4 IS POPULATED + (1:31!P5:P6) BUT ONLY IF J5:J6 IS POPULATED + (1:31!P7:P8) BUT ONLY IF J7:J8 IS POPULATED. I need to put this all in to one formula. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| summary sheet across multiple sheets | Excel Discussion (Misc queries) | |||
| Create summary sheet of last row of info from other sheets | Excel Worksheet Functions | |||
| Summary Sheet help with multiple sheets | Excel Discussion (Misc queries) | |||
| Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) | |||
| linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
Threaded Mode
