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:O1820))