9
9105st
I am trying to figure out a way to use SUMIF to calculate a quantity
used from a tank over time.
The total tank volume readings are entered into the cell range at
specified intervals. As product is used from the tank, the total
volume readings are reduced for the next entry. As long as product is
being used, the volume is reduced for each succesive reading. If a
delivery is made to the tank, the tank is refilled and the quantity is
increased.
To derive quantity used in a given time span, the difference needs to
be found between the volume entries and each difference value needs to
be summed together to yield the volume used over a given time span.
If the value in the current cell is greater than the previous cell
value in the range, then that indicates a delivery and the difference
needs to be ignored and not summed.
I have figured out how to do this using a combination of several
individual cell formulas and a SUM of all of those. But my question
is, is there an easier and simpler way to do this using the SUMIF
function (non-2007 Excel version)?
TIA - Chris
used from a tank over time.
The total tank volume readings are entered into the cell range at
specified intervals. As product is used from the tank, the total
volume readings are reduced for the next entry. As long as product is
being used, the volume is reduced for each succesive reading. If a
delivery is made to the tank, the tank is refilled and the quantity is
increased.
To derive quantity used in a given time span, the difference needs to
be found between the volume entries and each difference value needs to
be summed together to yield the volume used over a given time span.
If the value in the current cell is greater than the previous cell
value in the range, then that indicates a delivery and the difference
needs to be ignored and not summed.
I have figured out how to do this using a combination of several
individual cell formulas and a SUM of all of those. But my question
is, is there an easier and simpler way to do this using the SUMIF
function (non-2007 Excel version)?
TIA - Chris