I'm trying to use SUMIF and OFFSET to find any instances of a word and sum the contents of the cells 19 spaces down and 2 to the left of each instance. The idea is that I've created a score sheet that takes up a page (33 rows and columns A-H each). I want to be able to paste a sheet and have a formula find the team name and sum the team's scores from all games.
Thanks!
Bookmarks