Formula

  • Thread starter Thread starter Rex Sexton
  • Start date Start date
R

Rex Sexton

This may be simple but this is what I need to do, if
someone can help I would be very grateful.

I have a material list in which I want to enter
quantities from every invoice I recieve. The next column
I want a formaul to tally every entry for that product.
For Example:

Product Invoice Cumilative Total
3" Wye 2 10

The next invoice may have a quantity of 5 so I want to be
able to enter 5 over top of the 2 in the invoice column
and have the Total column add the 10 already bought to
the new number which would be 5 to make 15. So on and so
on.....

Please advise
 
Back
Top