sumifs messes up sometimes while changing order of names - better formula please?

Hi guys,

I hope you will find a solution to my problem, any help greatly appreciated. Workbook attached.
I have a workbook where I record nursery fees weekly, and there's a formula that causes some trouble in payment columns
1. column [L] should sum only card payments from "PP" worksheet
2. column [M] should sum only cash payments
3. column [N] should sum : vouch, chq and bacs payments

it is set up like this using sumifs formula, but sometimes when I change children names order [clear cells with one child name and put it for example on 2 rows down, and the child from two rows down to the first child's cell, then payments made by the second child appear on first child's payments and other way round.

Could anyone look into the file and advice what other formula I could use to make it better, or how to change the existing one so it works PLEASE?

Maaaany thanks!

Hi Pauleyb thanks for your fast reply.
Yes the formulas seem to be okay, i have no idea what causes the problem, but when i redo and copy down it seems to solve the problem.
So children are sorted alphabetically to match weekly managers reports. Sometimes I change the order, that's why I added one extra column, to match manager's order so it's faster to process. Sometimes when i change the order [by hitting delete on name/surname and entering other childs details, the formula still "thinks" it's the "old" child in there.. and summing his/her payments normally where it used to be. Sometimes I can do this action without any formulas issue but sometimes it can be a pain. It's hard to explain or show, I tried to swap the names as in the workbook attached.

Becuase it's hard to give an example I hoped someone could come up with a better way of getting card/cash/vouch/chq/bacs payments from parents payments tab "PP"

PP sheet has - sheet name, in column A and same time equals cell D1 of each sheet.