Hi Thank you for your response.

I'll try to be more clear in the example below.
There could be N/A in each column. The only one that count are if they are in column Ends & col Start
date falls in the parameters (ie. before March 2018). If the N/A appears in Starts and the date in End
is within the parameter (ie. greater than March 2018) then I do not want to count it.

Start Ends LOB
12-1-16 4-1-20 Nuclear - Count as 1 Started before March 2018 and ends after March 2018
6-1-14 5-1-16 N/A - Does not count as ends before March 2018
7-1-18 9-1-22 Corporate - Count as 1
9-1-15 N/A Nuclear - Count as Start date is before March 2018 and there is no end date
10-1-18 9-1-17 Enterprise - Does not count as Ends prior to March 2018
N/A 5-1-14 N/A - Does not count as Ends prior to March 2018
N/A N/A N/A - Do not count LOB as there is not start or end date

I hope this is clearer. I appreciate your help