Hi All,
I have a complex SUMIF that I am having the hardest time with. I have worked my way around it by coming up with a crazy worksheet using all kinds of tricks but i was hoping i can calculate my number with a much simpler formula instead. I have attached a sample file with my issue layed out.
ColumnA = Departments
ColumnB = SUMIF results
ColumnD = Username
ColumnE = User's Number I want to SUM
ColumnsG:K = VLOOKUP table containing the Departments users are a part of (in multiple columns because a single user can be in multiple departments)
Bookmarks