Home

Running tally

%3CLINGO-SUB%20id%3D%22lingo-sub-702349%22%20slang%3D%22en-US%22%3ERunning%20tally%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-702349%22%20slang%3D%22en-US%22%3EI%20am%20trying%20to%20keep%20track%20of%20a%20200%20gallon%20Nitrogen%20tank.%20I%20need%20to%20be%20able%20to%20input%20a%20daily%20value%20and%20have%20excel%20tell%20me%20how%20much%20was%20used%20in%20a%2024hr.%20period.%20I%20need%20it%20to%20show%20positive%20and%20negative%20as%20this%20tank%20is%20topped%20off%20periodically%20and%20I%20would%20like%20to%20know%20how%20much%20was%20added.%20Being%20able%20to%20differentiate%20the%20days%20when%20Nitrogen%20was%20added%20would%20be%20great.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-702349%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-705557%22%20slang%3D%22en-US%22%3ERe%3A%20Running%20tally%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-705557%22%20slang%3D%22en-US%22%3EPlease%20attach%20a%20sample%20Excel%20file%20with%20your%20sample%20date%20and%20your%20manually%20entered%20results.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-705563%22%20slang%3D%22en-US%22%3ERe%3A%20Running%20tally%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-705563%22%20slang%3D%22en-US%22%3EI%20need%20this%20to%20auto%20calculate%20for%20the%20entire%20page%20as%20a%20new%20entry%20will%20be%20added%20daily.%20Thanks%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-705975%22%20slang%3D%22en-US%22%3ERe%3A%20Running%20tally%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-705975%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F362658%22%20target%3D%22_blank%22%3E%40Josephlesane%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20attached%20file%2C%20the%20formula%20in%20C2%2C%20copied%20down%20rows%2C%20is%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3DIF(AND(ISNUMBER(%24B1)%2C%24B2%26gt%3B%24B1)%2C%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%24B2-%24B1%2C%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E0)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3EConversely%2C%20the%20formula%20in%20D2%2C%20copied%20down%20rows%2C%20is%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3DIF(AND(ISNUMBER(%24B1)%2C%24B2%26lt%3B%24B1)%2C%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E%24B1-%24B2%2C%3C%2FSTRONG%3E%3CBR%20%2F%3E%3CSTRONG%3E0)%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Josephlesane
New Contributor
I am trying to keep track of a 200 gallon Nitrogen tank. I need to be able to input a daily value and have excel tell me how much was used in a 24hr. period. I need it to show positive and negative as this tank is topped off periodically and I would like to know how much was added. Being able to differentiate the days when Nitrogen was added would be great.
3 Replies
Please attach a sample Excel file with your sample date and your manually entered results.
I need this to auto calculate for the entire page as a new entry will be added daily. Thanks

@Josephlesane 

In the attached file, the formula in C2, copied down rows, is: 

=IF(AND(ISNUMBER($B1),$B2>$B1),
$B2-$B1,
0)

Conversely, the formula in D2, copied down rows, is: 

=IF(AND(ISNUMBER($B1),$B2<$B1),
$B1-$B2,
0)

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
21 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies