Counting total based on Status & Date

leah cattarin
leah cattarin ✭✭
edited 12/09/19 in Formulas and Functions


I'm trying to calculate the total value of all the won job in this financial year. I have to reference 3 columns for this (Date submitted, Value, Status) not sure how to make the formula. 

This is as far as I got. Please help. 

=SUMIFS([Tender Due]:[Tender Due], >DATE(2018, 6, 30), <DATE(2018, 6, 30), Status:Status, "Won") + Value:Value

please help.png


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!