SumProduct not working as expected
Posted on 2011-10-24
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
Filtering manually I get fewer rows.