Count IF
 

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???

Count IF
 

Try
=SUMPRODUCT(((AX13:AX47="")+(AX13:AX47TODAY())))


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=116208

Count IF
 

That worked beautifully! Thanks!


"NBVC" wrote:


Try
=SUMPRODUCT(((AX13:AX47="")+(AX13:AX47TODAY())))


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=116208