I'm hoping someone is able to help with something I've been stuck with.
I'm looking for an easy way to sum up all invoices that aren't paid - ie a formula in the yellow cells to return the values shown.
I could do lots of sumifs, but I have over 50+ invoices per centre (on each row) and it would get really messy.
Is anyone able to help please? Thanks in advance!
I'm looking for an easy way to sum up all invoices that aren't paid - ie a formula in the yellow cells to return the values shown.
I could do lots of sumifs, but I have over 50+ invoices per centre (on each row) and it would get really messy.
Is anyone able to help please? Thanks in advance!
| Centre | TOTAL NOT PAID | Invoice No | Amount | Payment Date | Invoice No | Amount | Payment Date | Invoice No | Amount | Payment Date | Invoice No | Amount | Payment Date |
| A | £0.00 | INV1 | £100.00 | 05/01/2022 | INV7 | £100.00 | 05/01/2022 | INV13 | £100.00 | 05/01/2022 | INV19 | £100.00 | 05/01/2022 |
| B | £100.00 | INV2 | £100.00 | NOT PAID | INV8 | £100.00 | 05/01/2022 | INV14 | £100.00 | 05/01/2022 | INV20 | £100.00 | 05/01/2022 |
| C | £0.00 | INV3 | £100.00 | 05/01/2022 | INV9 | £100.00 | 05/01/2022 | INV15 | £100.00 | 05/01/2022 | INV21 | £100.00 | 05/01/2022 |
| D | £200.00 | INV4 | £100.00 | 05/01/2022 | INV10 | £100.00 | NOT PAID | INV16 | £100.00 | NOT PAID | INV22 | £100.00 | 05/01/2022 |
| E | £0.00 | INV5 | £100.00 | 05/01/2022 | INV11 | £100.00 | 05/01/2022 | INV17 | £100.00 | 05/01/2022 | INV23 | £100.00 | 05/01/2022 |
| F | £0.00 | INV6 | £100.00 | 05/01/2022 | INV12 | £100.00 | 05/01/2022 | INV18 | £100.00 | 05/01/2022 | INV24 | £100.00 | 05/01/2022 |
