SUMIF function not adding all non blank cells before todays date

[unokam]

I am having issues where the Sumif function is not adding all the non blank cell in a column.

I have cell in D and E columns combined so the fomula reads like this : =SUMIF(D9:E268,"<"&TODAY(),$I$8:$I$268)
The above formula should sum all the numbers in column I if the date is less than today.

In columns D9:E268 it has Dates from Aug 31st 2015 up to Aug 30th 2016.
In cells I8 thru I268 may contain numbers or not.

The issue here is that SumIf formula above will not add all of the numbers in Column I8:I268 its missing numbers.
Returned value comes out to 18.99 where if I select the column where the date is before today the Sum comes out to 19.51

[Jonmo1]

You can't have a multi column criteria range like that.

I'm afraid you'd have to do

=SUMIF(D9:D268,"<"&TODAY(),$I$8:$I$268)+SUMIF(E9:E268,"<"&TODAY(),$I$8:$I$268)