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?

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