您的尝试是无效的语法。尝试这样：
=ARRAYFORMULA(QUERY({MId(spgsh1378!B1:B, 7, 5), spgsh1378!A1:AP}, "select Col3,Col1,sum(Col14) where Col1 is not null group by Col1,Col3 label sum(Col14)''", 0))=ARRAYFORMULA(QUERY({QUERY({MId('grouping project'!A1:A, 8, 5), 'grouping project'!A1:AO}, "select Col1,sum(Col3) where Col1 is not null group by Col1 label Col1'month',sum(Col3)'net'",1), IF(LEN(QUERY(QUERY({MId('grouping project'!A1:A, 8, 5), 'grouping project'!A1:AO}, "select Col1,sum(Col3) where Col1 is not null group by Col1 label Col1'month',sum(Col3)'net'",1),"select Col1",0)), {"";MonTH(LEFt( QUERY(QUERY({MId('grouping project'!A1:A, 8, 5), 'grouping project'!A1:AO}, "select Col1,sum(Col3) where Col1 is not null group by Col1 label Col1'month',sum(Col3)'net'",1),"select Col1 offset 1", 0), 3)&1)&RIGHt( QUERY(QUERY({MId('grouping project'!A1:A, 8, 5), 'grouping project'!A1:AO}, "select Col1,sum(Col3) where Col1 is not null group by Col1 label Col1'month',sum(Col3)'net'",1),"select Col1 offset 1", 0), 2)}, )*1}, "select Col1,Col2 order by Col3"))
