Sumifs with an "OR"?

[gheyman]

I have Dates running down column D5:D100 In Column F I have Dates and Blanks running down F5:100 In Cell A1 I have a Date and down Column BN I have values which is my sum range.
Column D is when they started a Project. F is when they finished. If F is blank that means its still in process. I am trying to count how many projects were in process on a specific date (A1)

So in this example Projects 1,2,4 and 5 were in process. So my formula should result in a answer of 4

2/31/2019

Proj 1 2/1/2019 3/1/2019 1
Proj 2 1/1/2019 1
Proj 3 12/1/2018 2/1/2019 1
Proj 4 11/1/2018 4/1/2019 1
Proj 5 01/1/2019 3/1/2019 1
Proj 6 10/1/2018 2/1/2018 1
Proj 7 1


I started to write a SumIf but then I was baffled on how to handle the blanks.


I need a type of sumif formula that says if A1 is => than the date in D and A1 is <= then the date in F or if F is blank then sum BN

 

[etaf]

you could do two sumifs() and add together

I need a type of sumif formula that says if A1 is => than the date in D and A1 is <= then

=SUMIFS( BN1:BN1000, D1:D1000, "> ="&A1, F1:F1000, "< ="&A1 ) + SUMIFS( BN1:BN1000, F1:F1000, "", D1:D1000, "> ="&A1 )