Thank you for the reply back. However, the formula did not address the Pending column. Within the Combined formula table, when I placed skp in the Pending column, the formula accounted only the Resolute column. In other words, if skp is placed in the Pending column and n/a is placed in the Resolute column, I should end up with a total amount of 4.