| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search across multiple sheets and subtotal.
The SUMIF worksheet function may help. You need one for each sheet and then
you can sum them to get the great total. Example where the numbers in L1:L20 that have "xx" in column K are summed: =SUMIF(K1:K20,"xx",L1:L20) -- Jim Rech Excel MVP |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| search, copy and paste through multiple sheets | Excel Discussion (Misc queries) | |||
| Create a cell that will search multiple sheets for entered string. | Excel Discussion (Misc queries) | |||
| Search in Multiple Sheets | Excel Discussion (Misc queries) | |||
| Search multiple sheets and return largest number found | Excel Worksheet Functions | |||
| Subtotal across multiple sheets | Excel Discussion (Misc queries) | |||
Threaded Mode
