Formula help: if project type = x then sum revenue?

edited 12/09/19 in Formulas and Functions

I'm having a bear of a time with forumlas (as you can see from my posting history).  I'd like to add up the MRR by project type automatically. I'm currently calculating this by hand and it is time consuming and error prone. 


See screen shot.


I'd like to count the total MRR for all projects labeled MgdServ as an example. Is this possible? 





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!