I have a Numbers table that has numerical values in one column with a date in another column and a name in a third one. I want to sum all the values in this table for a particular name where the date is between two values. Is it possible to use SUMIF to obtain this sum? I've used SUMIF a lot but only where I'm summing values with a particular name.
I'm currently using macOS Monterey 12.6.3.
iMac (2017 – 2020)
Not with SUMIF but it can be done with SUMIFS
If you are hard coding the date into the function like I did, using the DATE function is preferable to using a text date because it is unambiguous, unlike text (is "04/10/2023" April 10th or Oct 4th?). If you replace the DATE function with a cell reference to a date in a Date&Time formatted cell, that is also unambiguous.
Not with SUMIF but it can be done with SUMIFS
If you are hard coding the date into the function like I did, using the DATE function is preferable to using a text date because it is unambiguous, unlike text (is "04/10/2023" April 10th or Oct 4th?). If you replace the DATE function with a cell reference to a date in a Date&Time formatted cell, that is also unambiguous.
Many thanks for the reply.
My situation is a bit more complicated. My column A contains money payments while column D contains the names of the recipients, and there are many payments at different times to each of the recipients. I want to work out how much money was paid to a particular recipient during the period set by my dates criteria.
Sorry I was quite wrong, hadn't quite understood that SUMIFS did allow several different criteria to be added to the formula - silly of me! Now got this working as I wanted.
Question about SUMIF
