SUm based on mor than 5 or 6 criteria

[rz6657]

So basically i want to sum based on more than 5 or 6 criteria. I have a sumif but it only goes to a max of 3 conditions. Please help. I've attached a sample.

[thecrell]

=SUMIFS allows for multiple criteria ranges for one sum range. Try that

[rz6657]

I currently do have a sumifs but it only allows 3 max... any suggestions? This is what I'm using now: =SUMIFS('Data Dump'!I:I,'Data Dump'!$F:$F,Table!$D5,'Data Dump'!$C:$C,Table!$B5,'Data Dump'!$E:$E,Table!$C5)

[thecrell]

As far as I know, there is no pre defined limit on how many criteria you can have on SUMIFS. Remember though, that the criteria in the SUMIFS are AND rather than OR. So you have SUMIFS(sum_range, Criteria_Range1, Criteria1 AND Criteria_Range2, Criteria2....) so you ranges have to satisfy all the criteria to be summed....try multiple SUMIFS with independent criteria like SUMIFS(sum_range, independent criteria range1, independent criteria1, dependent criteria range1, dependent criteria1) + SUMIFS(sum_range, independent criteria range2, independent criteria2)...etc. Check that your conditions can be satisfied. Alternatively, attach a sample file for me to have a look at.

[e.isayev]

Sumifs function can sum up to 255 criteria (as i remember)
But i had a look to your table and its not designed in proper way. For example: month names are different in two tabels.
Thus i decided to use sumproduct formula
=SUMPRODUCT(IFERROR(INDEX('Data Dump'!$4:$20,MATCH(Table!$C6,'Data Dump'!$O$4:$O$20,0),MATCH(TRIM(Table!F$5&" Budget Cost"),'Data Dump'!$3:$3,0)),0)*('Data Dump'!$C$4:$C$20=Table!$D$2)*('Data Dump'!$P$4:$P$20=Table!$G$2)*('Data Dump'!$Q$4:$Q$20=Table!$J$2)*('Data Dump'!$L$4:$L$20=Table!$M$2))

But with a little chnage on your table you can use sumifs formula too, which is easiest way to sum criterias