Forum Discussion
Excel formulas
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
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
Thank you for your help
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