Hi All,

I noticed a formula isn't working. Does anyone know how to correct
it?

Formula is {=IF(AND(COUNTIF(ANeedToFinalizeColumn,"<Collect payment/
update payment
method")=0,COUNTIF(AmountDueToQCPColumn,"<0")),"W arning","")}

Where ANeedToFinalizeColumn is named as =TRANSACTIONS!$AD$7:$AH$138
Where AmountDueToQCPColumn is named as =TRANSACTIONS!$K$7:$K$138

If one of the five "A Need To Finalize Columns" does not have "Collect
payment/update payment method" and there is a number in the "Amount
Due To QCP Column", return "Warning" so we don't forget to collect the
payment.

Thank you for reading my post,

Michele