I am using a formula in column A to count the number of pump entries in column B starting at row 3. The number of entries in column B is unknown in length depending on the number of pumps in the hospital. I stopped the formula at row 11 (it might extend to row 100 for that day) because I need to modify the formula to take in account column C. If column C has a date (started scanning in new pump serial numbers that day) in it the cell counter in row A needs to start at 1 again and continue on until the next entered date in Column C. I would like to keep the function of column A showing no entry when column B has no entry although there should not be any blank cells in column B if every pump gets scanned into it. Notice the cell count in column A starts at 1 again because of date change. The last thing to think about would be a formula in the last cell row that would give a running total number of pumps in Column B. Any ideas would be greatly appreciated.
Use formula to auto number adjacent column to data being used



Re: Use formula to auto number adjacent column to data being used
Hello,
Try in
A3 =IF(C3<>"",1,A2+1) and fill down 
Re: Use formula to auto number adjacent column to data being used
Pike, thanks for the quick response and answer it works great for this project. I also added =SUBTOTAL(2,B3:B1500) to get the total number of cells used in the column. Is there a way to make the range dynamic in this formula?

Re: Use formula to auto number adjacent column to data being used
what do mean?

Re: Use formula to auto number adjacent column to data being used
B3:B1500 is a static range, can the formula automatically find the last entry in the column as new data is entered?


Re: Use formula to auto number adjacent column to data being used
Hello,
You will have to show this in a example workbook as I don't understand ? what cell is the formula in?
remember I know nothing about what the project is about 
Re: Use formula to auto number adjacent column to data being used
Hi,
You can use this formula =Count(B:B) or =Subtotal(2,B:B)

Re: Use formula to auto number adjacent column to data being used
Tom thats it, sometimes simple eludes me thanks to you and Pike for your suggestions, learned a lot on this project
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!