B: Date (mm/dd/yy)
I want to sum column
C every time column
A is a specific name & the corresponding date is before 2020
Small sample/Example of what I'm trying to work out:
=SUMIFS(C1:C10, A1:A10, "=Bob", B1:B10, "< Date(2020,1,1))
What am I doing wrong? I know it has to do with inputting the date for "criteria 2"