Hello - would I be able to get some help with a SUMIFS problem? Please see attached. I have multiple criteria I need to add to the SUMIFS formula on Master Output tab adding up to one sum in cell C2 (i.e. there's a 6262, but I need 6270, 6277, etc from column E on 09 Data tab), but I want to have them all in one formula. I believe I need to enter an INDEX (MATCH) formula in there somewhere but not the slightest idea where and I've hit a roadblock. Please advise.
Thanks,
Mark
SUMIFS HELP.xlsx
Hi Mark,
Welcome to ExcelFox !!!
Try
=SUMPRODUCT(--('09 Data'!$C$2:$C$16=A2),--('09 Data'!$F$2:$F$16="31"),--ISNUMBER(MATCH(LEFT('09 Data'!$A$2:$A$16,4),{"6262","6270","6277"},0)),'09 Data'!$D$2:$D$16)
adjust the range accordingly.
HTH
Cheers !
Excel Range to BBCode Table
Use Social Networking Tools If You Like the Answers !
Message to Cross Posters
@ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
Hi Mark,
Welcome to ExcelFox community.
Don't understand what you intend to achieve. If you take out ,'09 Data'!E:E,"6262" from the formula you have already used, wouldn't it give for all values of column E (ie, 6262,6270,6277)
A dream is not something you see when you are asleep, but something you strive for when you are awake.
It's usually a bad idea to say that something can't be done.
The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve
Join us at Facebook
Posting Permissions
Reply With Quote
Bookmarks