Good evening,
I am wondering if it is possible to use a Table as criteria in a SUMIFS formula. I used {} to include a smaller list of critiera; however that list has grown to over 400+ items. Please see below for curent formula:
=SUMIFS('Raw Data'!$BT$2:$BT$22735,'Raw Data'!$CI$2:$CI$22735,"At IDC",'Raw Data'!$B$2:$B$22735,{"24766471","25126081","23754675","25207479","25585706","25125999","25585730","25294210","22376936","25770100","25294021","24934160","25294357","25738112","24589104","25585241","25439918"})
Is it possible to to replace the bracketed section above with Table1 or something of that nature instead of typing in all 400+ values.
Bookmarks