SUMIF Statement help

[brandon16]

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

 

[AliGW]

If Comp Date (column E) is >01/01/2016 and < 01/02/2016

Do you mean not to include 01/01?

 

[brandon16]

Do you mean not to include 01/01?

Yes

 

[brandon16]

Yes

any.ideas.please?

 

[brandon16]

Is there anyone who can assist with my query please?

 

[Grant22]

=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!