Column A: Name Column B: Date (mm/dd/yy) Column C: Value

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"

  • Welcome. Please remember that as per site guidelines when an answer addresses your question, you should accept it so others can benefit as well. Jan 13, 2020 at 21:01

1 Answer 1


There are two ways to use dates alongside SUMIFS

either using the DATE function

=SUMIFS($C$1:$C$10, $A$1:$A$10, "=bob", $B$1:$B$10, "<="&date(2019,12,25))

or the actual date

=SUMIFS($C$1:$C$10, $A$1:$A$10, "=bob", $B$1:$B$10, "<12/25/2019")

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.