Link to home
Start Free TrialLog in
Avatar of avoorheis
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<>"100")*(Final!$M$2:$M$21291<>"Yes")*(Final!$AC$2:$AC$21291="Easy"))
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
Avatar of barry houdini
barry houdini
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of avoorheis
avoorheis

ASKER

I'm glad I'm not losing my mind.
thanks