SUMIFS and Sheet Summary Date


Hello all,

I am wondering if it is possible to use the date in a sheet summary to pull all data for a specific date.

I have a current formula that looks like this:

=SUMIFS(Payed:Payed, Date:Date, Date#, Denomination:Denomination, ="$0.01")

The formula is looking through Date:Date to find dates that match Date#, which is the sheet summary date. I am trying to get this formula to return the sum of Payed for rows where Date# and $0.01 are true, but this returns $0.00 even though I know for sure that there are rows where Date# and $0.01 are true.

Thanks in advance.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!