Good catch. The result of column T is not text as I assumed. I changed
€œTrue€� to TRUE and it worked. Thanks for your help.

One of the other responders suggested {=SUM(IF($H$28:$H$2000="Secure CE
Lead",IF($T$28:$T$2000=TRUE,AF28:AF2000,0),0))} which also works just fine.
Is there any advantage either way?


"Peo Sjoblom" wrote:

A couple of things, you can try

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

instead since "True" looks for the text whereas TRUE would be a result
of lets say =A20

If that does not work then you must have either hidden characters in
H28:H2000 like extra spaces or the values in AF28:AF2000 are text.

But I assume you have totaled them when using a filter so that doesn't
seem to be the problem


Regards,

Peo Sjoblom


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?