Get instant live expert help on sumif array

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I cannot figure out why my array formula isn't working! The formula starts in A3 =IFERROR(MATCH($F3,SUMIF(OFFSET($H3,0,MATCH($G3,$H$1:$CV$1,0)-1,1,ROW($1:$161)),">0"),1)+1,"NOT STARTED")
Solved by A. E. in 12 mins
I need to sum multiple columns with multiple rows based on criteria. I'm currently using a SumIf with offset formula. However, instead of returning the sum with the 12 columns I intend, it's only returning the sum of the first column in the array. Please help!
Solved by X. C. in 18 mins
Hi there. Please could you help me to turn this formula into an array formula to be used across the range C43:C450 =round(if($C43="",sumif($B44:$B90,$B43,AA44:AA90),SUMIFS(Cashbook!D:D,Cashbook!K:K,B43,Cashbook!L:L,C43, Cashbook!T:T,"")+SUMIFS(Cashbook!H:H,Cashbook!K:K,B43,Cashbook!L:L,C43, Cashbook!T:T,"")),0)
Solved by C. C. in 15 mins
SUMIF won't work. I type =SUMIF(D11:D15,">50")
Solved by A. F. in 13 mins
The following formula is repeated on multiple rows. Would it be possible (and efficient) to turn it into an array formula? I'm working in Google Sheets but I presume the same principles apply... =round(if(C43="",sumif($B44:$B94,$B43,F44:F90),iferror(VLOOKUP(C43,indirect("'"&B43&"'!B$13:D$58"),3,FALSE),"")),0)
Solved by X. C. in 17 mins