Sheet Summary Help - IF Status and Date greater than
I am trying to displat a Metrix on a Dash. I am using a sheet summary. Is it possible to write a formula that would show only items entered in 2021? The sheet goes back to 2016.
IF Status = Complete And Date greater than 12/31/2021
Currently the formula is: =COUNTIF(Status:Status, "Complete") but this shows over 4000+ orders.
Thank you in Advance.
Help Article Resources
Check out the Formula Handbook template!