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?
So, I want to find how many rows will be left if I filter where columns are
I <> 100
M<> Yes
Filtering manually I get fewer rows.
any ideas?
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


regards, barry
avoorheisAuthor Commented:
I'm glad I'm not losing my mind.
avoorheisAuthor Commented:
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.