How to set up a formula to show remaining items as used

  • Thread starter Thread starter Leonard
  • Start date Start date
L

Leonard

How do I set up a formula to show the decrease in prescription refills as I
order refills?
i.e. 10 refills less those ordered will show how many refills remaining.
 
It all depends on how your data is laid out. We could make a zillion guesses
and still be wrong......please provide more details

Vaya con Dios,
Chuck, CABGx3
 
Leonard,
Assuming the following:
Column A -Name
Column B - # of refills
Column C - # of refills left
Column D thru M - dates of refills
Column D thru M format as date (3/14/01)
Column B & C format as number zero decimals
Column C - "=SUM(A2-(COUNTA(C2:M2)))"

This will work for upto 10 refills, if there are more, then change the "M"
to the correct number of columns needed.
hth
:-)
 
Back
Top