Jun 30 2021 05:28 AM - edited Jun 30 2021 06:03 AM
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 appreciated
Jun 30 2021 05:37 AM
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.
Jun 30 2021 06:11 AM
Jun 30 2021 10:02 AM
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