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:
Is it possible to to replace the bracketed section above with Table1 or something of that nature instead of typing in all 400+ values.
Please Login or Register to view this content.
Put the criteria in a range of cells then use this syntax:
=SUMPRODUCT(SUMIFS('Raw Data'!$BT$2:$BT$22735,'Raw Data'!$CI$2:$CI$22735,"At IDC",'Raw Data'!$B$2:$B$22735,range))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Use SUMPRODUCT
Assuming Criteria_Table in W1:W100
Please Login or Register to view this content.
Quang PT
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks