Hello, it's my first time posting so I hope this is alright. I'm trying to get the sum from a table, of all the numbers in multiple columns (separated by columns with unnecessary information), also based on an IF check for a person's name in a column on the left. I'll post my formula below. It isn't working, could anyone help me understand why? Or suggest any better alternative? The range will become larger every week, so I want a formula that's not too long.
=SUMIFS('2018 WK1-26'!$G:$DG,'2018 WK1-26'!$B:$B,Summary!$B16,'2018 WK1-26'!$D$7:$DG$7,"Amt")
What I was trying to do, was have it do a check on the names in one column, and then do a second check for the word "Amt" in the row with the column headers, and have it sum all of the cells under each Amt column for each name. I hope I'm explaining this adequately.
Bookmarks