Counting rows that have data

G

gavinB

I would like to count the rows that have data in them.
I have used the function
rows(a1:a7) = 7

A
1 x
2 x
3
4 x
5
6 x
7 x

but only data is only is 5.
 

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

Section and Page numbering 0
Filtering data 2
Count the remaining weekdays in a data range excluding holidays and start/end dates 5
Goal Seeking via Excel 0
Find first and last cells in range, return info beside 3
What Multiple functions do I need? 2
Match and delete rows on two different sheets from reference numbers 4
Arriving at totals 2

Top