Sum of Column with Multiple Criteria

Options

Help! For some reason I'm getting a "0" as an answer... so I must be doing something wrong.

I am trying to sum column "# of Lives" based on multiple criteria - 2 versions:

1) Sum of # of Lives, when Partner = Bob, and Date = 11/1/2022

2) Sum of # of Lives, when Partner = Bob, and Date = 11/1/2022, and Status = Processing


Here are my formulas - let me know what I'm doing wrong!

1) =SUMIFS({# of Lives},{Partner},"Bob",{Date},DATE(22, 11, 1))

2) =SUMIFS({# of Lives},{Partner},"Bob",{Date},DATE(22, 11, 1),{Status},"Processing")


Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!