Your formula format looks correct. Is Autofilter returning more results, or
less? Check to make sure that when you filter the F column, you exclude the
date in Q1 (difference between = and alone)

Beyond that, we'd need more info about what your data looks like exactly. As
a way of error checking, perhaps break your sumproduct down into 100 rows,
and compare results. See if there's some set of cells that is throwing things
off.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"PAL" wrote:

I am using the formula below and it seems to work fine.

As an array:

=SUMPRODUCT(--('Enroll I'!$O$2:$O$2741="Regular"),--('Enroll
I'!$F$2:$F$2741Q1),--('Enroll I'!$N$2:$N$2741="No Planned Data"))

When I check the calculations on the source sheet using AutoFilter, the
numbers don't agree. When I remove the second condition, -('Enroll
I'!$F$2:$F$2741Q1)
It works and the Autofilter comes up with the same number as the
calculation. Q1 is a date, so I am asking for those later than this date.

Is the Autofilter the problem or the formula?

Thanks.