Looking to create a formula in the yellow highlighted area that will search for The value in column H in the "overview" sheet, and sum together the corresponding values in the Calculations chart. The formula should also only sum up the values in either Control or Test depending on what column it belongs to.
For example, In cell I2, it should sum together 83+53.
- According to Overview sheet, Consideration (A5) has values "Somewhat likely" and "very likely"
- Therefore, the 53 refers to Consideration "somewhat likely" while 83 refers to Consideration "Very Likely" in Control column of Calculations Sheet
Is such formula possible? or do i need to break this down more?? Appreciate any help!
Bookmarks