I believe this will work: (--($H$28:$H$2000="Secure CE
Lead"),--($T$28:$T$2000="True"),--($AF$28:$AF$2000))

Dave
--
Brevity is the soul of wit.


"Dave Shultz" wrote:

I want to sum the values in AF28:AF2000 but only if the following two
conditions are met:

First, only if $H$28:$H$2000="Secure CE Lead" and second, only if
$T$28:$T$2000="True". I am using the following formula which returns 0.00 in
error.

=SUMPRODUCT(--($H$28:$H$2000="Secure CE
Lead"),--($T$28:$T$2000="True"),AF28:AF2000)

When I apply a filter to columns H and T and filter on "Secure CE Lead" and
€œTrue€� I can manually sum the values in AF resulting in the correct value of
430. What am I doing wrong?