Advertisement
Guest User

Untitled

a guest
Jun 27th, 2019
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 KB | None | 0 0
  1. ={"Total", "Monthly average"; ARRAYFORMULA(IF(LEN(A3:A),
  2. {MMULT(IF(B3:M<>"", B3:M, 0), TRANSPOSE(COLUMN(B3:M3))^0),
  3. MMULT(IF(B3:M<>"", B3:M, 0), TRANSPOSE(COLUMN(B3:M3))^0)/COUNTA(B3:M3)}, ))}
  4.  
  5. ={"Total", ARRAYFORMULA(IF(LEN(INDIRECT("B2:"&ADDRESS(2, MONTH(TODAY())+1, 4))),
  6. TRANSPOSE(MMULT(TRANSPOSE(IF(INDIRECT("B3:M"&ROW()-1)<>"",
  7. INDIRECT("B3:M"&ROW()-1), 0)), ROW(INDIRECT("B3:M"&ROW()-1))^0)), ))}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement