Help needed with a function
I am wondering if it is possible to have a cell populate itself with a number that equates to the number of rows that are being filled in. For example, I have a table that my team need to fill with different sets of data (date, account name, contract value, etc), and each row represents a bid that they have done in that month. I am interested in having a cell (below the table) that will automatically populate itself with a number that will equate to the number of rows that have been filled in. That way I know how many bids they've done that month.
Any ideas?
Thanks in advance :)
eladamir1984, Good
eladamir1984, Good afternoon.
Supposing that ALL lines filled have the date filled, like:
Column A = DATE
Lines from 1 to 100
You can do:
Formula --> =COUNTIF( A1:A100 , ">''" )
Please, tell us if it worked for you.
I hope it helps.
Belo Horizonte, Brazil
Marcílio Lobão