Home

Add to sum only if it is an integer

%3CLINGO-SUB%20id%3D%22lingo-sub-445709%22%20slang%3D%22en-US%22%3EAdd%20to%20sum%20only%20if%20it%20is%20an%20integer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-445709%22%20slang%3D%22en-US%22%3E%3CP%3EGreetings%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20high%20vis%20workload%20planning%20sheet%20I%20am%20trying%20to%20improve.%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20desired%20state%20is%20that%20the%20user%20can%20enter%20the%20amount%20of%20hours%20certain%20things%20took%2Fwill%20take.%3CBR%20%2F%3EThe%20default%20of%20that%20cell%20is%20%22Not-Entered%22%20and%20color%20coded%20red%20if%20it%20is%20anything%20less%20than%200.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20would%20I%20go%20about%20making%20that%20cell%20not%20added%20to%20the%20total%20of%20all%20those%20cells%20until%20an%20integer%20is%20entered%2C%20that%20way%20the%20total%20is%20able%20to%20add%20without%20errors%20with%20the%20default%20%22Not-Entered%22%20still%20in%20place%2C%20and%20you're%20able%20to%20see%20the%20total%20of%20what%20has%20been%20entered%20thus%20far.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-445709%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-446079%22%20slang%3D%22en-US%22%3ERe%3A%20Add%20to%20sum%20only%20if%20it%20is%20an%20integer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-446079%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F320150%22%20target%3D%22_blank%22%3E%40LandenBrown%3C%2FA%3E%26nbsp%3B%2C%20you%20may%20use%20your%20total%20with%20SUM%20which%20ignores%20any%20text.%20If%20you%20calculate%20it%20like%20%3DA1%2BA5%2BA9%20when%20%3DSUM(A1%2CA5%2CA9)%3C%2FP%3E%3C%2FLINGO-BODY%3E
LandenBrown
Occasional Visitor

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 that cell is "Not-Entered" and color coded red if it is anything less than 0.

 

How would I go about making that cell not added to the total of all those cells until an integer is entered, that way the total is able to add without errors with the default "Not-Entered" still in place, and you're able to see the total of what has been entered thus far. 

1 Reply
Highlighted

@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)

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies