I have a number of columns with whole numbers and half numbers. But the "sum of " formula will not calculate the half numbers, it rounds them up to whole numbers which gives the incorrect figure at the end. How do I make it calculate a half as a half not a whole?
Solved by Z. F. in 16 mins