SUMIFS - Multiple Formulas
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.