Sum if based on multiple conditions
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?
|