Forum Discussion

David_Plane_1939's avatar
David_Plane_1939
Copper Contributor
Apr 08, 2023

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.
Formulas and Functions
PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Apr 08, 2023

 

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?

Resources