HSAR
Banned - Rules violations
- Joined
- Jul 6, 2020
- Messages
- 37
- Office Version
- 2016
- Platform
- Windows
Hi team, Using below Query formula it is working perfectly but there is 1 issue in it, that if first Column is empty such as "AB" it will not work (Unable to parse query string for Function QUERY parameter 2: AVG_SUM_ONLY_NUMERIC) that error is occur.
I have multiple sheets where mostly multiple columns are empty i mean If AB is empty then AC has values then AD is empty and so on..
please help in this regard.
=QUERY(A3:AZ27,"Select A, SUM(AB), SUM(AC), SUM(AD), SUM(AE), SUM(AF), SUM(AG), SUM(AH) Where A is not null Group by A LABEL A 'SuitA', SUM(AB) 'Jan', SUM(AC) 'FEB', SUM(AD) 'MAR', SUM(AE) 'APR', SUM(AF) 'MAY', SUM(AG) 'JUN', SUM(AH) 'JUL' ",1)
I have multiple sheets where mostly multiple columns are empty i mean If AB is empty then AC has values then AD is empty and so on..
please help in this regard.
=QUERY(A3:AZ27,"Select A, SUM(AB), SUM(AC), SUM(AD), SUM(AE), SUM(AF), SUM(AG), SUM(AH) Where A is not null Group by A LABEL A 'SuitA', SUM(AB) 'Jan', SUM(AC) 'FEB', SUM(AD) 'MAR', SUM(AE) 'APR', SUM(AF) 'MAY', SUM(AG) 'JUN', SUM(AH) 'JUL' ",1)
