sumproduct to sum rather than count

[detrie]

Excel 2003

All
This formula will count the occurrences and works great.
I need to use this criteria to get the SUM of nmCapex (a named range) but am not sure how to do it

=SUMPRODUCT(--(nmIOT=D5)*(nmEngageType="PC")*(--(NOT(ISNUMBER(FIND("Cancelled",nmStatus))))))

 

[detrie]

RESOLVED: sumproduct to sum rather than count

=SUMPRODUCT((nmCapex) * (nmIOT=D5)*(nmEngageType="PC")*((NOT(ISNUMBER(FIND("Cancelled",nmStatus))))))