I am using a vlookup to assign points to a team in a sports league based on their result against a specific team. An example of formula I m using for that is; =IF(EXACT(E3,“Win”),VLOOKUP(B3,standings.$A$2:$F$48,5,0),VLOOKUP(B3,standings.$A$2:$F$48,6,0))

This works fine, I have a result for all 20 matches this team played. My question is how do I sum the results? My results are in G3-G19, yet =SUM(G3:G19) yields an answer of 0.

Thanks,

Mike