Counting Cells

G

Guest

I have a column of numbers, 1-31. Each number is the number of a day of the
month. Some days are missing and a blank has been left for those days (in
the column).
Can someone help me with this problem? I want to return the count for the
days that are listed (omitting the blanks) but I only want to count the days
that are less than or equal to =day(today()). Can someone show me how to
write this? It's driving me mad. Thanks for any help.
 
B

Bob Phillips

=COUNTA(INDIRECT("A1:A"&DAY(TODAY())))

--

HTH

RP
(remove nothere from the email address if mailing direct)
 

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

need help writing function 9
Excel Formula - Count Dates from another Sheet 8
Adding up total hours worked on employee schedule using various criteria 0
Counting rows 4
Formula for Counta 3
Sumproducting counting blanks 4
Counting Blank Cells until end of Column 3
Attendance tracker last 30 days 1

Top