Actually, there's no need to coerce the last argument with a double
negative since Column A already contains numerical values...

=SUMPRODUCT(--(B1:B100="Paid"),--(C1:C10=4811),A1:A100)

Hope this helps!

In article ,
"Alan" wrote:

=SUMPRODUCT(--(B1:B100="Paid"),--(C1:C10=4045),--(A1:A100))
=SUMPRODUCT(--(B1:B100="Paid"),--(C1:C10=4811),--(A1:A100))