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

Options

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!

Tags:

• ✭✭✭✭✭✭
Options

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

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!