ok i have a basic work sheet that tells me that if you bet every 2nd half over the last 279 nba games where you were geting atleast a .5 advantage over the game line you would be up 21 units. i just use the formula =sum(g2:g272).
The problem is that is the only formula that i know. i keep the differnce between the game line and half time line in column E. I keep the adding in column g. Meaning that if the bet was a win a 1 is put in the cell if it was a loss -1.1 is put in the cell. Now lets say i want to get a sum but i only want to use games where their column G cell =8. I will try to draw a crude example

G1=8 E1=1
G2=4 E2=1
g3=5 E3=1

now as we can see if we just use the basic sum formula we will get 3. How do i get it to only use the games where the g column is 8?