I am using a sumifs function with multiple criteria ranges and criteria. If one of the criteria ranges has the possibility of 2 criteria i am using the following:
=SUMIFS(B:B,C:C,{"Unit1","Unit2"},D:D,e4,E:E,f4)
I want to replace the text references Unit 1 and Unit 2 to a cell reference....however I cannot figure out how...
Bookmarks