P
Подскажите плз в чем причина
=QUERY(H2:I;"select H, I where H > date '"&ТЕКСТ(O1;"yyyy-mm-dd")&"' GROUP BY I, H")
https://docs.google.com/spreadsheets/d/1WdIb94VDkjPnEZ4eprzwdwPUmaiUEDMG/edit#gid=1319430760&range=L2
Size: a a a
P
A
={ "Дата"; ArrayFormula(ЕСЛИ(G2:G="";"";TO_DATE(ОКРУГЛВНИЗ(G2:G)))) }
P
={ "Дата"; ArrayFormula(ЕСЛИ(G2:G="";"";TO_DATE(ОКРУГЛВНИЗ(G2:G)))) }
A
A
=QUERY(H2:I;"select month(H)+1,count(I) GROUP BY month(H)+1 ")
A
K
A
K
K
EN
=QUERY(H2:I;"select month(H)+1,count(I) GROUP BY month(H)+1 ")
A
EN
A
EN
A
EN
A
A