countif with auto filter

  • Thread starter Thread starter jwells2001
  • Start date Start date
J

jwells2001

I have two columns of data, and I need to find a formula that will count the
number of entries that meet certain criteria in both columns. The kicker is
that I need to be able to filter the data.
Here is what I used initially but of course it won't work when I filter one
of the columns.
=SUMPRODUCT(--(I10:I182="ind"),--(O10:O182>0))
 
Try this:

=SUMPRODUCT(SUBTOTAL(3,OFFSET(I10:I182,ROW(I10:I182)-ROW(I10),0,1)),--(I10:I182="ind"),--(O10:O182>0))
 
Back
Top