Forum Discussion
SUBTOTAL in Excel only works with integer numbers.
SUBTOTAL in Excel only works with integer numbers. When I try to sum decimal numbers it always returns zero.
David_Plane_1939 wrote:SUBTOTAL in Excel only works with integer numbers.
The statement is simply not true. Perhaps you formula is trying to count the entries rather than sum them?
Thank you for your reply. I have used the Excel SUBTOTAL function successfully for years, with no problems. I am indeed asking for the SUM. Unfortunately NOW it seems to have gone haywire and only sums (correclty by the way) integer number.