Can you apply the auto filter to data that are filtered?

[Skip in FL]

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!

 

[smartin]

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

 

[Skip in FL]

Thanks for replying, but that won't work either.

The SUMPRODUCT function restrictions (i.e., that the arrays be the same size
and that no array can be an entire column) are too restrictive to be of any
value, and I'm not even sure if SUMPRODUCT will work ONLY on the filtered
data.

But thanks for your time!

 

[T. Valko]

I need to do something similar to a

SUMIF feature on the filtered data.
Is this possible?

Yes. What are the details?

 

[smartin]

Would you show a few rows of data, requirements, and expected results?
Perhaps there is another way.