Database sum query

[Nishant_Dhamale]

"select sum[Bin Quantity] from [Sheet1$] group by [Item Name] "
when i using above query the syntax error is coming

[tazunnisa.badavide (Taj)]

@Nishant_Dhamale

select sum[Bin Quantity] from [Sheet1$] group by [Item Name] "
when i using above query the syntax error is coming

SELECT [Item Name], SUM([Bin Quantity]) AS [Total Quantity]
FROM [Sheet1$]
GROUP BY [Item Name]
TRY THIS

[lrtetala (Lakshman Reddy)]

Hi @Nishant_Dhamale

Try this

SELECT SUM('Bin Quantity') FROM [Sheet1$] GROUP BY [Item Name]

[Parvathy (PS Parvathy)]

Hi @Nishant_Dhamale

Try using the below syntax:

SELECT [Item Name], SUM([Bin Quantity]) as TotalQuantity
FROM [Sheet1$]
GROUP BY [Item Name]

Hope it helps!!
Regards