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)))
CLICK HERE to find out more related problems solutions.
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)))
CLICK HERE to find out more related problems solutions.