SUMIFS - Multiple Formulas

edited 12/09/19 in Formulas and Functions

Hi I am trying to calculate the revenue for each leg of an event. The drop down options are "Spring", "Fall" or "Both". Using the following statements individually I can get part of the answer:

=SUMIF(CHILDREN(Roadshow21), "Spring", CHILDREN([Forecast Amount]21))

=SUMIF(CHILDREN(Roadshow21), "Both", CHILDREN([Forecast Amount]21)) / 2

With my limited ability I can't work out a way to combine this into the information I need. In other words, To get the true vale of "Spring" I need to be able to add 50% of the revenue from anything marked as "Both".

Hope this makes sense to someone in the Community.

Thank you in advance.





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!