Excel – I need the number in a cell to countdown when data is entered into other cells.

microsoft excelvlookupworksheet-function

I'm making a sheet to keep track of the number of software licenses.

In cell B1 I have the number 35 representing 35 licenses. As they are assigned to systems in cells C5-C40 I would like the total in cell B1 to count down reflecting remaining licenses. So each time data is entered into any cell C5-C40 that number in B1 will count down

Thanks.

Best Answer

If nothing will be in the cells prior to you entering data:

=COUNTIF(C5:C40,"")
Related Question