|I am attempting to create an equation that will refer to Column A, and if it has the correct text, then it will include the number in Column C in a sum formula. For the moment, because I do not have that many rows, I've been using this:|
This formula is working exactly like I want it to, except that I don't want to have to add A4, A5, A6, etc to the formula. I keep feeling like I'm getting really close to the solution, but then it slips away. Is there any way I can have the formula automatically check each row within Column A for the specific word, and only use the correct Column Cs in the Sum? Thanks so much.