SumProduct not working as expected

Posted on 2011-10-24
Last Modified: 2012-05-12
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?
Question by:avoorheis
    LVL 50

    Accepted Solution

    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

    Author Comment

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

    Author Closing Comment


    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
    This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
    The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now