Adding a subset of rows of cells, SUM, based on Lookup

[DMB]

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?

[keithl816]

Hi DMB,

Take a look at this link.

http://www.contextures.com/xlFunctions01.html


Larry