| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding a subset of rows of cells, SUM, based on Lookup
I can filter a worksheet with the lookup tool but I would like to use it
through out the file. All of the worksheets in the current workbook and I want to sum a colum of the result set! How do I do this? Can I make a macro to do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding a subset of rows of cells, SUM, based on Lookup
Hi DMB, Take a look at this link. http://www.contextures.com/xlFunctions01.html Larry -- keithl816 ------------------------------------------------------------------------ keithl816's Profile: http://www.excelforum.com/member.php...o&userid=21287 View this thread: http://www.excelforum.com/showthread...hreadid=499176 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert a number of rows based on a value in a cell on active row | Excel Discussion (Misc queries) | |||
| locking cells based on results at runtime | Excel Worksheet Functions | |||
| Subtract a group of cells from a total based on ending date | Excel Discussion (Misc queries) | |||
| Auto populate cells based on 2 cells division. | Excel Discussion (Misc queries) | |||
| Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) | |||
Linear Mode
