Forum Discussion
LandenBrown
Apr 12, 2019Copper Contributor
Add to sum only if it is an integer
Greetings, I have a high vis workload planning sheet I am trying to improve. The desired state is that the user can enter the amount of hours certain things took/will take. The default of tha...
SergeiBaklan
Apr 12, 2019Diamond Contributor
LandenBrown , you may use your total with SUM which ignores any text. If you calculate it like =A1+A5+A9 when =SUM(A1,A5,A9)