Count cell A if cell A is <= cell B

Using the TRADES sheet in the attached WB as reference... I actually would like to find the percentage of...

(Count non-blank cells of Table1[DD] if <= Table1[STOP] AND if Table1[STOP] is not blank)

divided by...

(Count Table1[STOP] if not blank)

I've tried something like...

=IF(Table[STOP],"<>",(COUNTIFS(Table1[DD],"<>","<=Table1[STOP]")/COUNT(Table1[STOP])

Here is exactly what you asked for, but give this some thought to make sure it's really what you need for your purposes:

Formula:

Please Login or Register  to view this content.

The way you wrote this it sounds like you want:

The count of rows where DD and STOP are both non-blank AND DD < STOP

divided by

The count of rows where STOP is non-blank.

However, the count of rows where STOP is non-blank includes rows where DD is blank, which are not included in the top number. Are you sure that is really the calculation you need?