# Sumifs with an "OR"?

#### gheyman

##### Well-known Member
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

### Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

#### etaf

##### Well-known Member
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 )

Last edited:

Replies
18
Views
232
Replies
2
Views
187
Replies
7
Views
304
Replies
1
Views
166
Replies
1
Views
203

1,195,617
Messages
6,010,728
Members
441,565
Latest member
menangterus556

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back