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

How to count the numbers in a Word document? 0
How to display zero value in blank fields of Cross Tab query 0
Subtracting two cell dates and highlight if over due by a certain amount of days 0
Count Blank Cells with Conditions 3
Using <= in countifs statement 1
subtract one cell from each cell in a range and count instances 2
Count Number of Unique Cells That Don't Have Certain Characters 0
SUMPRODUCT formula I think w/ wild card & number vs number as text 8

Top