Google Spreadsheet SUMIF Date Comparison

google-sheets, google-sheets-formula

Solution

Just a small error with your SUMIF syntax:

`=SUMIF(H$2:H;"<"&A4;I$2:I)`

Problem

I'm trying to get this aggregate date comparison working, and I thought I understood the syntax, but it's clearly not working. Can anyone correct the formula for me? I'm trying to sum up the amounts in column I, where the date in H is prior to the date in A My formula is `=SUMIF(H$2:H,H$2:H<A4, I$2:I)`

Original source