Forum Discussion
Excel Formula Help (I assume SUM IF)
I copied this spreadsheet from a website into an Excel spreadsheet. I need to be able to edit the Paid column but need the formula in the Balance column to adjust to an accurate result. The Team row with THE DEACON would be the desired accurate Balance I need for the total spreadsheet. I assume SUM IF, but am not sure.
| Team | Entry | Costs | Paid | Winnings | Paid Out | Balance |
| BAILEY'S BUMS | 200 | 125 | 0 | 0 | 0 | -325 |
| DISCO BISCUIT | 200 | 70 | 0 | 0 | 0 | -270 |
| EL PELON | 200 | 70 | 0 | 841 | 0 | 571 |
| GATOR & HOOPER | 200 | 230 | 0 | 542 | 0 | 112 |
| HUNDIN JUNGEN | 200 | 55 | 0 | 0 | 0 | -255 |
| POSSUM KING | 200 | 90 | 0 | 400 | 0 | 110 |
| ROOKIE MISTAKES | 200 | 0 | 0 | 0 | 0 | -200 |
| THE BUZZKILLERS | 200 | 175 | 0 | 0 | 0 | -375 |
| THE DEACON | 200 | 225 | 200 | 1341 | 0 | 1116 |
| Trust "The Process" | 200 | 85 | 0 | 0 | 0 | -285 |
| 2000 | 1125 | 200 | 3124 | 0 | 199 |
2 Replies
- did my suggestion worked for you?
thanks try this simple formula at G2 (Balance) =IF(E2=0,F2-D2+E2-B2-C2,D2+E2-B2-C2)
(copied down) ... thanks
