Excel Formula Help (I assume SUM IF)

[Brandon Becker]

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]

try this simple formula at G2 (Balance) =IF(E2=0,F2-D2+E2-B2-C2,D2+E2-B2-C2)

 (copied down) ... thanks

[#3]

did my suggestion worked for you?
thanks