avoorheis
asked on
SumProduct not working as expected
I thought I'd be able to count the number of row that matched the criteria below, but, when I manually filter, I get a different count. Can I not do this with sumproduct?
=SUMPRODUCT((Final!$I$2:$I $21291<>"1 00")*(Fina l!$M$2:$M$ 21291<>"Ye s")*(Final !$AC$2:$AC $21291="Ea sy"))
So, I want to find how many rows will be left if I filter where columns are
I <> 100
M<> Yes
AC=Easy
Filtering manually I get fewer rows.
any ideas?
thanks
alan
=SUMPRODUCT((Final!$I$2:$I
So, I want to find how many rows will be left if I filter where columns are
I <> 100
M<> Yes
AC=Easy
Filtering manually I get fewer rows.
any ideas?
thanks
alan
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks
ASKER