Excel formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-2501594%22%20slang%3D%22en-US%22%3EExcel%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2501594%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20get%20a%20formula%20that%20will%20not%20change%20total%20gallons%20pumped%20and%20the%20balance%2C%20when%20the%20is%20a%20X%20in%20the%20risers%20column%20I've%20tried%20%3Dsumifs.%20any%20help%20would%20be%20greatly%20appreciated%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%20(5)_LI.jpg%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F292550i814077B8B9B0600F%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%20(5)_LI.jpg%22%20alt%3D%22Screenshot%20(5)_LI.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2501594%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2501654%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2501654%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1091983%22%20target%3D%22_blank%22%3E%40Bryan_Reay%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAn%20image%20is%20allegedly%20worth%201%2C000%20words.%20It's%20not%20worth%20anywhere%20near%20as%20much%20as%20an%20actual%20spreadsheet%2C%20however%2C%20when%20you're%20looking%20for%20help.%20So%20please%20post%20a%20copy%20of%20that%20spreadsheet%20from%20which%20you%20took%20the%20image%20shot.%20That%20way%20we%20can%20work%20with%20the%20actual%2C%20rather%20than%20creating%20another%20one.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20let%20us%20know%20how%20you%20wrote%20your%20%3CSTRONG%3E%3DSUMIF%3C%2FSTRONG%3E%20formula%2C%20what%20happened%2C%20what%20you%20wanted%20to%20happen.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20assuming%20you%20want%20the%20total%20up%20at%20the%20top%20to%20count%20all%20lines%20except%20those%20with%20X%20in%20the%20risers%20column%2C%20but%20you%20make%20it%20easier%20to%20help%20you%20by%20being%20very%20specific%20on%20desired%20outcome.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2502821%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2502821%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1091983%22%20target%3D%22_blank%22%3E%40Bryan_Reay%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20attached%2C%20SUMIF(What%20are%20you%20evaluating%2C%20what%20are%20you%20evaluating%20against%2C%20and%20what%20to%20total%20if%20it%20meets%20the%20criteria)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethis%20was%20the%20formula%20in%20cell%20F5%3A%26nbsp%3B%3DSUMIF(O13%3AO37%2C%22%22%2CE13%3AE37)%2C%20I'm%20evaluating%20on%20a%20blank%20field%20to%20total%20for%20non%20riser%20gas%20pumped.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ein%20I5%2C%20I%20used%20formula%26nbsp%3B%3DSUMIF(O13%3AO37%2C%22X%22%2CE13%3AE37)%20assuming%20that%20you%20wanted%20to%20total%20the%20risers%20separately.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDidn't%20see%20a%20cell%20built%20out%20for%20the%20balance%20though.%20Lemme%20know%20if%20you%20have%20questions%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I'm trying to get a formula that will not change total gallons pumped and the balance, when the is a X in the risers column I've tried =sumifs. any help would be greatly appreciatedScreenshot (5)_LI.jpg

3 Replies

@Bryan_Reay 

An image is allegedly worth 1,000 words. It's not worth anywhere near as much as an actual spreadsheet, however, when you're looking for help. So please post a copy of that spreadsheet from which you took the image shot. That way we can work with the actual, rather than creating another one.

 

And let us know how you wrote your =SUMIF formula, what happened, what you wanted to happen.

 

I'm assuming you want the total up at the top to count all lines except those with X in the risers column, but you make it easier to help you by being very specific on desired outcome.

Thank you, I uploaded the spreadsheet, anything in the risers marked with a X I don't want counted in the total gallons pumped or to affect the balance. I need to separate them and right now it totals in both the total gallons pumped and gallons pumped at the risers and changes the balance.
Thank you for your help

@Bryan_Reay 

See attached, SUMIF(What are you evaluating, what are you evaluating against, and what to total if it meets the criteria)

 

this was the formula in cell F5: =SUMIF(O13:O37,"",E13:E37), I'm evaluating on a blank field to total for non riser gas pumped. 

 

in I5, I used formula =SUMIF(O13:O37,"X",E13:E37) assuming that you wanted to total the risers separately. 

 

Didn't see a cell built out for the balance though. Lemme know if you have questions