Count IF

K

Kris

I am trying to figure out a formula that will count two separate things in
one column.

I want to count the blank cells in a range and within the same range I want
to count the dates greater than today.

So in the cell range I want Excel to count two separate things and add them
together.

I know how to count the blank cells by using =COUNTIF(AX13:AX47,"") what I
don't know how to do is add the calculation of how to count in the same range
for dates that are greater than today and add these two counts together.

Any help???
 

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

subtract one cell from each cell in a range and count instances 2
Count distinct days from two groups of days 3
COUNTIF Non Contiguous Cells Q 3
COUNT rows on external sheet if between date range 3
Countif and values greater than zero for a named range 1
Excel Formula - Count Dates from another Sheet 8
Excel Formula 2
Count function 7

Top