# SUMIF Statement help

#### brandon16

##### Board Regular
Hi,

I need a formula in the Total column (F) to show the following -

If Comp Date (column E) is >01/01/2016 and < 01/02/2016 and the stage (column D) is application complete then total amount (Column C)

 inquiry date name amount stage comp date Total 01/01/2016 Steve 25000 application complete 01/06/2016 01/01/2016 brian 625000 application complete 01/09/2016 01/01/2016 john 225000 application complete 01/06/2016

<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>

Thanks

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.
If Comp Date (column E) is >01/01/2016 and < 01/02/2016

Do you mean not to include 01/01?

Is there anyone who can assist with my query please?

=IF((D24="application complete") &E24>1/1/16,C24,0)

If you put this in column F and then just copy it straight down it will apply to each of your other cells. It returns the value in column C IF column D reads application complete AND column E is later than 1/1/16. If you need to do days before 1-1-16 then you'll need to add another OR statement to use the date before the 1st. Hope this helps!

Replies
7
Views
660
Replies
0
Views
459
Replies
3
Views
833
Replies
0
Views
402
Replies
2
Views
887

1,203,082
Messages
6,053,417
Members
444,662
Latest member
AaronPMH

### 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