Column C - N represent month from 1 - 12
I want to find which month have a sum greater than 200.
I use if formula and result is ok but it's too long
Any help to improve the formula
1 Answers
O2 cell:
=ARRAYFORMULA(MMULT(C2:N*1, TRANSPOSE(COLUMN(C:N)^0)))
P2 cell:
=ARRAYFORMULA(IF(C2:C>=200, 1,
IF(MMULT(C2:D*1, ROW(A1:A2) ^0)>=200, 2,
IF(MMULT(C2:E*1, ROW(A1:A3) ^0)>=200, 3,
IF(MMULT(C2:F*1, ROW(A1:A4) ^0)>=200, 4,
IF(MMULT(C2:G*1, ROW(A1:A5) ^0)>=200, 5,
IF(MMULT(C2:H*1, ROW(A1:A6) ^0)>=200, 6,
IF(MMULT(C2:I*1, ROW(A1:A7) ^0)>=200, 7,
IF(MMULT(C2:J*1, ROW(A1:A8) ^0)>=200, 8,
IF(MMULT(C2:K*1, ROW(A1:A9) ^0)>=200, 9,
IF(MMULT(C2:L*1, ROW(A1:A10)^0)>=200, 10,
IF(MMULT(C2:M*1, ROW(A1:A11)^0)>=200, 11,
IF(MMULT(C2:N*1, ROW(A1:A12)^0)>=200, 12, )))))))))))))
Related