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

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!

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

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

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!

"smartin" wrote:

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

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

I need to do something similar to a
SUMIF feature on the filtered data.
Is this possible?

Yes. What are the details?

--
Biff
Microsoft Excel MVP


"Skip in FL" <Skip in wrote in message
...
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!

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

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

Skip in FL wrote:
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!

"smartin" wrote:

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