SUM Value With Multiple Criteria In Same Column

[MarkJohn]

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

239

[Admin]

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

[Excel Fox]

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)