Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ={"Total", "Monthly average"; ARRAYFORMULA(IF(LEN(A3:A),
- {MMULT(IF(B3:M<>"", B3:M, 0), TRANSPOSE(COLUMN(B3:M3))^0),
- MMULT(IF(B3:M<>"", B3:M, 0), TRANSPOSE(COLUMN(B3:M3))^0)/COUNTA(B3:M3)}, ))}
- ={"Total", ARRAYFORMULA(IF(LEN(INDIRECT("B2:"&ADDRESS(2, MONTH(TODAY())+1, 4))),
- TRANSPOSE(MMULT(TRANSPOSE(IF(INDIRECT("B3:M"&ROW()-1)<>"",
- INDIRECT("B3:M"&ROW()-1), 0)), ROW(INDIRECT("B3:M"&ROW()-1))^0)), ))}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement