SUMIFS and Sheet Summary Date
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.
Help Article Resources
Check out the Formula Handbook template!