Dave,

A couple of possibilities.

First, if you want a sum, you should use the SUM function, not the
SUMPRODUCT function.

Second, the conditions need to be written using the "IF" function. You need
to add something for the "FALSE" outcome of each "IF". Since you are doing
a SUM, I suggest "0" as the "FALSE" result.

Third, I'm not sure what the "--" in front of the two conditions does for
you. I don't think they should be there.

Finally, be sure that you use <CTRL<SHIFT<ENTER (all pressed at the same
time) to enter the formula as an array formula rather than a standard
formula.

The formula should be:

=SUM(IF($H$28:$H$2000="Secure CE
Lead",If($T$28:$T$2000="True",AF28:AF2000,0),0))

Good luck!

David


"Dave Shultz" <Dave wrote in message
...
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?