Get instant live expert help on sumifs array formula
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
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
I have a complicated array formula that I am trying to edit with weighted data, but I can't get the array to cooperate whereas everywhere else in the data set the following arrangement works perfectly: SUMIFS(InHome[Weight],InHome[Q1_2_1],"=1"). But including InHome[Weight], in the array causes a #VALUE! error. What am I doing wrong? Here is one of the arrays I am trying to edit: =SUM(IF((InHome[Q1_5_1]=1)+(InHome[Q1_6_1]=1)+(InHome[Q1_7_1]=1)+(InHome[Q1_8_1]=1),1,0))/B$5
Solved by K. A. in 29 mins
In tab Socal 1 Qtr, Continue my formula in Column E, based on my current formula add an additional sumifs formula (it will be something like Sumifs+sumifs). Sum range is tab booking, if quote date column F show no quote then sumifs based on column G and Column D.
Solved by T. W. in 13 mins
need help with sumifs formula in GSheets
Solved by X. A. in 22 mins
I need sumifs formula calculating the data mith multiple criteria
Solved by A. A. in 27 mins