Apr 08 2023 10:07 AM
SUBTOTAL in Excel only works with integer numbers. When I try to sum decimal numbers it always returns zero.
Apr 08 2023 10:43 AM
@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?
Apr 08 2023 10:49 AM
Apr 08 2023 11:16 AM
Most likely, the problem is: you and your computer do not agree on what the decimal point and thousands separator should be. Or for some other reason, Excel is treating the values as text.
Looks can be deceiving, and the format of the cells do not matter.
For the cells with numbers that are being ignored, use formulas of the form =ISTEXT(A1) to confirm that they are interpreted as text, not numbers.
There can be many reasons. Some things to look for:
1. Wayward characters in the data, notably CHAR(160), which looks like a space.
2. Incompatible currency symbol.
3. Incompatible decimal point and/or thousands separator.
4. Etc, etc, etc
If you need assistance, attach an example Excel file the duplicates the problem, or provide a download link to the file on a file-sharing website.
Apr 08 2023 11:30 AM