multiple conditions with Function Sumif

**benishiryo** · 01-24-2013, 10:06 PM

hi Punter, welcome to the forum. you dont need SUMIF if all you need is a single value. try:
=INDEX($B$2:$F$8,MATCH("Activity 2",$A$2:$A$8,0),MATCH(--("4jan13"),$B$1:$F$1,0))

or if there is a chance "Activity 2" appears more than once, then:
=SUMIF(A2:A8,"Activity 2",INDEX(B2:F8,,MATCH(--("4jan13"),B1:F1,0)))

"Activity 2" & --("4jan13") can be referred to a cell reference where such values exist

**Punter!** · 01-25-2013, 02:42 AM

Originally Posted by benishiryo

hi Punter, welcome to the forum. you dont need SUMIF if all you need is a single value. try:
=INDEX($B$2:$F$8,MATCH("Activity 2",$A$2:$A$8,0),MATCH(--("4jan13"),$B$1:$F$1,0))

or if there is a chance "Activity 2" appears more than once, then:
=SUMIF(A2:A8,"Activity 2",INDEX(B2:F8,,MATCH(--("4jan13"),B1:F1,0)))

"Activity 2" & --("4jan13") can be referred to a cell reference where such values exist

Thank You Very Much! I hardly use the deadly combo of Index & Match, if you can please help me understand this formula.