Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search across multiple sheets and subtotal.
I was hoping for a non-programming solution but can't find any
current excel NG more appropriate than this one. I have a workbook with sheets for each month. I want to find all rows where column k contains a particular word and total all the values from colum L on those rows ie they are expenses claim for each month, I want to add all particular claims for, say, fuel. I can combine the sheets and do a find all which would tell me how many rows but is there a way to do that bit more without a macro? |
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) |