A | B | C | D | F | ||||||||
1 | A001 | 1 | TRAD | 270.24 | ||||||||
2 | A001 | 1 | MEDIA | 373.28 | ||||||||
3 | A001 | 1 | DELIV | 221.19 | ||||||||
4 | A001 | 1 | DISC | 17.30 | 864.17 | |||||||
5 | A001 | 2 | TECH | 559.98 | ||||||||
6 | A001 | 2 | ADCV | 58.88 | ||||||||
7 | A001 | 2 | PNS | 160.56 | ||||||||
8 | A001 | 2 | DESIGN | 333.12 | ||||||||
9 | A001 | 2 | CONS | 42.76 | ||||||||
10 | A001 | 2 | REBT | 18.70 | 1155.30 | |||||||
11 | A002 | 7 | MEDIA | 210.88 | ||||||||
12 | A002 | 7 | DISC | 25.14 | 210.88 | |||||||
I need a sum formula in column F that will sum amounts in column D for all the same references in column B, if column A = A001 or A002 | ||||||||||||
but exclude amonts where col C = DISC or REBT. | ||||||||||||
I would like the result to be in the same row that as the last occurrence of the reference in col B | ||||||||||||
For all rows in the database that does not equal A001 or A002 do nothing |