GoogleSheet to Sum until empty row AND Group By “Personal”

try:

=ARRAYFORMULA(IFNA(VLOOKUP(H5:H, 
 QUERY({TO_DATE(B6:B), C6:C-B6:B, F6:F},
 "select Col1,sum(Col2) 
  where Col3 = 'Personal'
  group by Col1
  label sum(Col2)''"), 2, 0)))

enter image description here

CLICK HERE to find out more related problems solutions.

Leave a Comment

Your email address will not be published.

Scroll to Top