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?