Forum Discussion
Iterating through columns and counting if a cell in that row contains A, B, or C and summing
Hello, I have a large range of cells that each have a list associated with them, such as Bag, Box, Cart, Tray. Another column in the range of cells has months associated with the rows. My goal t...
=MAKEARRAY(COUNTA(B10:B13),
COUNTA(C9:E9),LAMBDA(r,c,SUM((E2:E7=INDEX(C9:E9,c))
*(A2:D7=INDEX(B10:B13,r)))))An alternative could be MAKEARRAY.