Using =SUMIFS and a specific date as criteria to total another column of data

Gavin Frank

Hello!

I am trying to use the =SUMIFS formula to sum up a range of donations that occurred on a specific date. Essentially, I have a giant list of donations, with a column that shows date, and a column that shows the donation total. I'd like to run a formula that will total all donations made on a specific date in that list. Here is the formula I am using and a screenshot of the sheet. Please help - I continuously get $0.00 as the total when using a Date as the criteria. But when I change the criteria to another column, that is not driven by a "Date", such as company, I get the formula to work. I have also tried the SUMIF formula as is written below with the same issue.

=SUMIFS(Deduction:Deduction, Date:Date, "06/07/20")

=SUMIF(Date:Date, 6 / 7 / 20, Deduction:Deduction)

Thank you!

Andrée Starå

Hi Gavin,

Try something like this.

You could also combine the formula with a so-called helper column that would be a date and select the date you want to reference there instead of in the formula.

=SUMIF(Date:Date; DATE(2020; 6; 22); Deduction:Deduction)

The same version but with the below changes for convenience.

=SUMIF(Date:Date, DATE(2020, 6, 22), Deduction:Deduction)

Depending on your country/region, you'll need to exchange the comma to a period and the semi-colon to a comma.

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!