Sum if status is approved and end date is in the future
I am trying to get the sum of approved projected expenses only. I can't figure it out I have been trying SUMIFS and SUM(AND formulas but can never get it to return a result. I can get one or the other to work, but it's important that only approved future expenses are summed. Below is a screenshot of the columns I'm working with.
I want to look at the approval status column for approved items only, and the end date column for future items only and then sum the projected expense column.
Help Article Resources
Check out the Formula Handbook template!