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
avoorheisAsked:
Who is Participating?
 
barry houdiniConnect With a Mentor Commented:
That looks like a valid formula but for numbers you would normally use 100 rather than "100" (unless column I is text-formatted) so try without quotes

=SUMPRODUCT((Final!$I$2:$I$21291<>100)*(Final!$M$2:$M$21291<>"Yes")*(Final!$AC$2:$AC$21291="Easy"))

regards, barry
0
 
avoorheisAuthor Commented:
I'm glad I'm not losing my mind.
0
 
avoorheisAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.