Calculate Multiple Criteria On Filtered List

  • Thread starter Thread starter ibo
  • Start date Start date
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 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...
 
Back
Top