If Statement to search a certain word in a group

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..

I created a pivot table on sheet 4. The info is grabbing from Tloopa-BK Payment sheet.

I just noticed something else. Where there are NSF payments the totals don't add up as they should... Is there a setting I need to change? For example - Sharon Baden - The total should be $1506.00 instead of $306.00. I know how its calculating but I don't want it to calculate like that and of course, there is no way to manually alter a pivot table.

Any help is appreciated.
Thank you,
Trish

I wish I could but my boss wants to see it there.