SUMIFS - Multiple Formulas

ChrisT
ChrisT
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.

CT

 

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!