I have to sum these columns and rows weekly and I am trying to find a way to make it easier.


example:

A B C D
name | input | output | received |
1 AP | 50 | 20 | 16
2 ANM | 5 | 3 | 7
3 AER | 12 | 8 | 4
4 AEP | 15 | 13 | 15

I need to add cells from ROWs 1/3, with Columns B/D AP/Input = 50 AP/recieved = 16 = 66 + AER/Input = 12 AER/recieved = 4 = 16, total answer needed is 66 + 16 = 82
this is a small example, i am using a sumif function but i have multiple columns and multiple rows for each final answer I need.
Thanks for trying.