| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum all sheets if Column L
Hi,
Is it possible to sum all sheets in a workbook within a range base on Column L I currently use the following formula which works if I have one sheet B5 =SUMIF(Week5!L9:L18,"Won",Week5!G9:G18) B6 =SUMIF(Week5!L9:L18,"Lost",Week5!G9:G1 B12 =SUMIF(Week5!L24:L33,"Won",Week5!G24:G33) B13 =SUMIF(Week5!L24:L33,"Lost",Week5!G24:G33) My workbook as week5 upto week 10 and every week I'll be adding a week, so I want to automate so that I don't have to manually add totals. Is this doable? Really appreciate any help I can get. Thanks Juan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| All sheets opening at column IV - help! | Excel Discussion (Misc queries) | |||
| Repeat column in all sheets | Excel Discussion (Misc queries) | |||
| Combining two work sheets using a column in both as a key | Excel Worksheet Functions | |||
| One cell from several sheets to one column | Excel Discussion (Misc queries) | |||
| How can give the same name to a row or column in different sheets. | Excel Discussion (Misc queries) | |||
Threaded Mode
