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

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