I'm hoping that someone can help me.
I need a formula that can provide counts with the following criteria - please assume XL2003. I have searched and searched - to no avail.
1. Data is filtered on one or more columns Assume data is filtered on column D - to exclude "Free"
2. Data Range (unfiltered) A8:A1000
2. I want to return a count of Unique values in column A - only visible cells.
3. However I haveadditional criteria (subject to change) in the data range - for example - where B8:B1000 <> "ABC" and F8:F:1000=57
This is basically the equivalent of a Select Distinct in SQL with multiple criteria returning a count.
I basically need to be able to combine Sumproduct (multiple criteria) and Subtotal (since the data is filtered).
In short I need to be able to show and update multiple counts on filtered data while specifying additional criteria in the formula such that the counts change as the filter changes.
Thanks in advance - if additional information is needed to understand what I am looking for - please let me know.
I need a formula that can provide counts with the following criteria - please assume XL2003. I have searched and searched - to no avail.
1. Data is filtered on one or more columns Assume data is filtered on column D - to exclude "Free"
2. Data Range (unfiltered) A8:A1000
2. I want to return a count of Unique values in column A - only visible cells.
3. However I haveadditional criteria (subject to change) in the data range - for example - where B8:B1000 <> "ABC" and F8:F:1000=57
This is basically the equivalent of a Select Distinct in SQL with multiple criteria returning a count.
I basically need to be able to combine Sumproduct (multiple criteria) and Subtotal (since the data is filtered).
In short I need to be able to show and update multiple counts on filtered data while specifying additional criteria in the formula such that the counts change as the filter changes.
Thanks in advance - if additional information is needed to understand what I am looking for - please let me know.
Last edited: