counting rows

E

ed

I suspect this is relatively easy but I'm not sure how to accomplish this. Is there a way to count the "non blank rows" in a specific column. We need to know the number of rows that have been filled in within each column....thanks
 
J

JudithJubilee

You can use the Counta function.

=COUNTA(A1:A1000)

This counts any cells within the range that have data in
them.

Hope this helps

Judith
-----Original Message-----
I suspect this is relatively easy but I'm not sure how
Click to expand...
to accomplish this. Is there a way to count the "non
blank rows" in a specific column. We need to know the
number of rows that have been filled in within each
column....thanks
 

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

Cumulative formula for word table 0
Dealing with a Pivot Table (when I don't want to) 0
Copy addition formula of non-consecutive horizontal cells 2
Sorting Multiple Tables 1
MS Project Import Error Row 1 Column 5 2
Need Help with a VBA subroutine 0
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
Indenting every other paragraph in Word at the same time? 0

Top