Thread: COUNTIF
View Single Post
  #2   Report Post  
Connie Martin
 
Posts: n/a
Default

Never mind! I figured it out. Posted my question too soon. I just used:
=COUNT(B1:B500) and it gives me the answer I want. I used row 500 because
that will always be well past the typed rows, so it will always ensure not to
miss counting any.

Connie


"Connie Martin" wrote:

What would the formula be to count the number of line items? If I have 383
rows typed, I want the formula to calculate that. If I add another 20 rows,
I want the formula to automatically update to 403.

Thank you
Connie Martin