Hello, I'm working on a spreadsheet where I need to count all the customers that have "paid in full" out of group.

Picture1.png

I need a formula that will say something like.. [B]If the customer still has a "Pending" payment, then it counts as 1 and goes to #of Clients Paying,
If all Paid, then its also a 1 but it goes in # Clients PIF, and if Cancelled, well you know... At the end all the 1's would be sum'd and added as a total in the section below

Is this possible?

I basically need to fill this section automatically:

# Clients PIF _____
# Clients Paying _____
# Clients Cancelled _____
Total _____


Thank you to anyone that can help me..