Hey guys, I am making an Excel (2004) spreadsheet to keep track of an office pool in which the participants pick sides on various Super Bowl Prop Bets. For example, in cell A3 it says "SBP v AI" which represents a bet. In cells C3, D3, etc. it says which side that the person is taking (either "SBP" or "AI"). I was wondering how I can tell Excel that if the text in B3 (which is saved for the actual result) matches the text in C3, then to add 1 point to a certain cell, say C45, and then also check cells D3, E3, etc and add points to D45, E45, etc. I'm pretty sure there is a function for this because somebody in another office pool did something similar last year for March Madness. Then, also, if there is some way to also calculate the percent correct, disregarding cells which the person left the answer blank. I'm not so sure about that one. Thank you guys very much!