View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
smartin smartin is offline
external usenet poster
 
Posts: 915
Default Can you apply the auto filter to data that are filtered?

Skip in FL wrote:
I know this sounds odd, but here's the deal:

I have filtered a set of data and need to filter it down even further. For
many reasons, the advance filter option won't work and the subtotal,9
function works only on the filtered data results.

I need to do something similar to a SUMIF feature on the filtered data.

Is this possible? I've tried playing around, tryng to find a workaround and
spent alot of time reading other posts here.....all to no avail.

Can anyone help me here?

Thanks!


Are you trying to sum on multiple conditions? This might be a solution:

http://xldynamic.com/source/xld.SUMPRODUCT.html