Hello, I have a screenshot here of a sum of ranges I am trying to do. In each of the tabs in the worksheet are tables with the same column headings the main sheet.
I defined L2:L6 as the name range to pick up from the other 5 worksheets of data. So basically I want to match the person's ID to their total in each term, and then use a SUM formula in column H to get their total for the year. I keep getting a #REF error and cannot figure out why.
What am I doing wrong? Perhaps my formula is too complicated for what I want?
Problem.PNG
Bookmarks