| Please help with the following request. I want to insert a formula in the green areas to automate the calculation. the data is coming from the table below. | |||||
| Sum if | Sum if | Sum | |||
| Code1 | Code 2 Positive | Code 2 Negative | Code 3 | ||
| WS3A | 13.00 | (5.00) | 2200 | ||
| WSJM | 7.00 | (12.00) | 1800 | ||
| WSIE | 0 | (9.00) | 600 | ||
| WS6A | 26.00 | (11.00) | 3200 | ||
| Total | 46.00 | (37.00) | 7,800.00 | ||
| Data: | ||
| Code 1 | Code 2 | Code 3 |
| WS3A | 5.00 | 100 |
| WS6A | 14.00 | 200 |
| WSJM | (4.00) | 300 |
| WSJM | (8.00) | 400 |
| WS3A | 8.00 | 500 |
| WSIE | (9.00) | 600 |
| WS3A | (4.00) | 700 |
| WS6A | (9.00) | 800 |
| WS3A | (1.00) | 900 |
| WS6A | 12.00 | 1000 |
| WSJM | 7.00 | 1100 |
| WS6A | (2.00) | 1200 |
| 9.00 | 7,800.00 |
