SUMIF Multiple criteria - issue with Between dates

[SkatePropertyTofuEquities]

Hi all,

I'm using a SUMIF function where the first criteria is an item (fuel), the second, greater than 08/01/2018 and the third is less than 15/01/2018. If that returns zero, I have it referring to a another cell to produce an estimate of the cost I am trying to find.

This issue is excel is including the upper date, so instead of being between 08/01 and 15/01 its including 15/01 figures.

=IF(SUMIFS(Journal!$B$4:$B$1000,Journal!$A$4:$A$1000,Cashflow!$B16,Journal!$C$4:$C$1000,">="&Cashflow!D$6,Journal!$C$4:$C$1000,"<="&Cashflow!E$6)=0,Estimates!$C16,SUMIFS(Journal!$B$4:$B$1000,Journal!$A$4:$A$1000,Cashflow!$B16,Journal!$C$4:$C$1000,">="&Cashflow!D$6,Journal!$C$4:$C$1000,"<="&Cashflow!E$6))

Where:
- Journal!$B$4:$B$1000 is the actual cost of items
- Journal!$A$4:$A$1000 is the name of items
- Cashflow!$B16 is the criteria for the name to meet
- Journal!$C$4:$C$1000 is the date at which the item was paid
-">="&Cashflow!D$6 above first date
<="&Cashflow!E$6 belove second date

Thanks in advance!

SPTE

 

[Special-K99]

If 15/01 is your upper date this is just a simple case of changing all <= to < (and probably >= to > too )