Sumifs with array

hi there. first to explain what went wrong.
pressing CTRL + SHIFT + ENTER has no effect on this. the problem is that you are doing SUMIFS on 4 types of criteria;
Does not equal Fedex
Does not equal Concur
Does not equal Postmaster
Does not equal space
so one useful trick to learn when understanding formulas is to press the F9 key to calculate. So go to the cell where the formula resides and click inside the formula bar. select the the whole formula and press F9. you get:
={389;472;379;447}
389 is summing those not equals to Fedex, 472 for those not equals to Concur, and so on. Excel can't present 4 values, so you need to sum that up. that is however not what you need.

so i will sum up those that are equals to those 4 instead. and use SUMPRODUCT in front instead of array formula:
=SUMPRODUCT(SUMIFS(DataTbl[Voucher Count],DataTbl[Month],J12,DataTbl[Year],J11,DataTbl[Group],H15,DataTbl[CG-type],InterType))

and then use the total sum of ALL CG-Type minus the ones above. that would give me Others:

Formula:

=SUMIFS(DataTbl[Voucher Count],DataTbl[Month],J12,DataTbl[Year],J11,DataTbl[Group],H15)-SUMPRODUCT(SUMIFS(DataTbl[Voucher Count],DataTbl[Month],J12,DataTbl[Year],J11,DataTbl[Group],H15,DataTbl[CG-type],InterType))