Cell H15 formula , Drag down
Code
=SUMPRODUCT((ISNUMBER(SEARCH($C$1:$C$10,B15)))*($F$1:$J$10>=--"1/11/2022")*($F$1:$J$10<=--"30/11/2022"))Posts by wk9128
-
-
Cell H2 formula , Drag down and across
Code=INDEX(IF(COLUMN(A$1)=1,$E:$E,$D:$D),-MOD(AGGREGATE(14,6,($C$2:$C$13=$G2)*$D$2:$D$13*1000-ROW($2:$13),1),-1000)) -
worksheet or tab name : Sheet1
Cell B2 formula , Drag down
Code=TEXTJOIN(",",,IF(ISNUMBER(FIND($A2,Sheet2!$B$2:$B$4)),Sheet2!$A$2:$A$4,"")) -
Try Cell C25 formula , Drag down
Code=SUMPRODUCT(($A$10:$A$21=$A25)*(YEAR($B$1)=--$C$3:$N$3)*(MONTH($B$1)=MONTH($C$7:$N$7))*(--$B$10:$B$21<=DAY($B$1))*$C$10:$N$21)