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

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

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.
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,105,841
Messages
5,507,613
Members
408,641
Latest member
billigee

This Week's Hot Topics

Top