COUNTIF

C

Connie Martin

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
 
C

Connie Martin

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Copy addition formula of non-consecutive horizontal cells 2
Count Number of Unique Cells That Don't Have Certain Characters 0
Using <= in countifs statement 1
Newbie Help - IF Yes No Function 0
Consolidation Table from Different Excel Tabs with Different Format 1
Excel Countif Function - Calculating Between Two Sets of Values 3
Display weeks from a Milestone 0

Top