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

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

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,108,644
Messages
5,524,048
Members
409,557
Latest member
lgambit

This Week's Hot Topics

Top