Advertisement
Guest User

Untitled

a guest
Jun 24th, 2019
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.41 KB | None | 0 0
  1. 12:00:00 x
  2. 10:00:00
  3. 13:00:00 x
  4.  
  5. =SUMIF(B:B, "=x", A:A)
  6.  
  7. =SUMPRODUCT((A1:A100)*(B1:B100="x"))
  8.  
  9. =TEXT(SUMIF(B:B, "=x", A:A), "[h]:mm:ss")
  10.  
  11. =TEXT(SUM(FILTER(A:A, B:B="x")), "[h]:mm:ss")
  12.  
  13. =ARRAYFORMULA(TEXT(SUM(IF(B:B="x", A:A, )), "[h]:mm:ss"))
  14.  
  15. =TEXT(SUM(QUERY(A:B, "select A where B ='x'")), "[h]:mm:ss")
  16.  
  17. =TEXT(SUMPRODUCT((B:B="x")*(A:A)), "[h]:mm:ss")
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement