Count if PaymentAgreed=Yes AND Paid=No

[john williams via AccessMonster.com]

an example:

Payment Agreed Paid

Yes Yes
Yes No
No No
Yes Yes
No No

(the fields are Yes/No fields, which are all checkboxes)

There are two records here that both have apayment agreed and are not paid.

how do i make a count formula to have it print "2"?

thanks in advance

 

[fredg]

an example:

Payment Agreed Paid

Yes Yes
Yes No
No No
Yes Yes
No No

(the fields are Yes/No fields, which are all checkboxes)

There are two records here that both have apayment agreed and are not paid.

how do i make a count formula to have it print "2"?

thanks in advance

=sum(IIf([PaymentAgreed]=-1 AND [Paid]=-1,1,0))