Calculate Multiple Criteria On Filtered List

I

ibo

Hi

I have a list of data (Range A11:Z65000) for which I would
like to calculate the occurance of certain values based upon
multiple criteria. Currently, I am using the following
formula to calculate the number of occurances for values
:

=SUMPRODUCT(K11:K65000;Z11:Z65000)

This works great on the entire range, however, when I
apply a filter, I would like to calculate the number of
occurances in the above manner for only those values
which are shown in the filter. In this case, the above
formula does not work, as it still counts the number of
values for the entire range, and not just for the values
that are showing.
Could someone please give a modificated/revised formula that would give me
what I am looking for.
Thanks

Ibo
 
I

ibo

I was mistaken it is working..thanks all.



ibo said:
Hello all.

Is there any news for me???..I really need it....

Thanks



=SUMPRODUCT(SUBTOTAL(3;OFFSET(A2:A100;ROW(A2:A100)-MIN(ROW(A2:A100));;1))*(A
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate the median value before a specified list 0
Excel formula help for calculating freight. 2
Add Values that Match 2 Criteria Q 1
Calculate Filtered Cells Only 7
Excel Countif Function - Calculating Between Two Sets of Values 3
VBA multiple list of values for variable 1
Formulas within list fail to update after sorting/filtering 0
Count if data falls within a range AND that has a certain criteria 1

Top