Get instant live expert help on sumifs vs sumif

I am trying to utilize a complicated sumif or sumifs formula that can pull a total amount from a date and a drop down box from another tab.

Hello I am looking for a SUMIFS formula where when I move the formula over to the next cell the SUMIFS sum column will move three columns over. The sumif formula in Cell C19 is =SUMIFS(TY!E:E,TY!$B:$B,TOTAL!$A$8,TY!$A:$A,TOTAL!$A$18) when I paste the formula over to cell D19 I need the formula to change from E:E to H:H

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)

SUMIFS(D6:D446,"*PLUK teacher income*",E6:E446 ,A6:A445,">=" &O2,A6:A445,"<=" &O3) I have a formula: SUMIF(D6:D446,"*PLUK teacher income*",E6:E446) I want to add te range between specific dates. I have this formula currently: SUMIFS(D6:D446,"*PLUK teacher income*",E6:E446 ,A6:A445,">=" &O2,A6:A445,"<=" &O3) A = date range O2 is date beginning O3 is date ending What am i missing!

Is there a way to compare all rows to each other? I have a large 3000 row spreadsheet, and on one column, I would like to compare row 1 vs 2, 1 vs 3, 1 vs 4, 1 vs 5, 1 vs 6.....2999 vs 3000. I know, that's 5 million combinations. I will be dividing the smaller number into the larger number, to get a percentage/correlation.