SUM Function not working in 365

[plantperson]

QT
1g
2g
3g
5g
8g
10G
15G
total
0
15
0
0
0
0
0
0
0​
0
3​
0
0
0
0
0
0
3​
0
19
0
2
0
0
0
0
0​
75​
0
0
0
0
0
0
0
75​

I am basically trying to find the sum of the different sizes of plants. There is a XLookup where it feeds the numbers in from a list, but the total is where I am inputting the formula of =SUM(K:G) and for some rows it returns the correct total and for others returns a 0.

I am on MSOffice365, I checked to make sure the numbers are not formatted into text.

 

[Joe4]

It looks like in that the rows where you are getting a zero, the numbers are left-justified in their cells.
That implies that the numbers, are in fact, entered as text and not numbers (and changing the format of the cells will NOT change that!).

If you select one of those columns, and go to the Data menu and select "Text to Columns" and click "Finish", that should convert those values to numbers.
You would need to do that on each of those columns.