Countif for varying dates

mlden

New Member
Joined
Aug 4, 2010
Messages
2
Hi,

I've looked through the boards, help files, etc. and haven't found anything that has given me exactly what I needed.

I have two columns: one is "scheduled end date" and the other is "actual end date". I want to count every instance where the actual end date (say in column B) is less than or equal to the associated scheduled end date (say in column A). It seems like it should be simple, but I can't get it to count right because I'm referencing varying dates throughout the column.

Also, I did manage to create conditional formatting to highlight in green every record where this is true (actual <= scheduled)... is there a way to just count wherever the conditional formatting is met?

Thank you so much in advance for any help.
 

Some videos you may like

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Perhaps

=SUMPRODUCT(--(B1:B10<>""),--(B1:B10<=A1:A10))
 

mlden

New Member
Joined
Aug 4, 2010
Messages
2
Thank you VoG, it works. I really appreciate you taking the time to answer my question.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,131
Messages
5,527,020
Members
409,736
Latest member
maanbunty

This Week's Hot Topics

Top