'Google Sheets: How do I execute a formula in a column based on the value of a dropdown in another column?
Context: I have an allocation Google Sheet.
- Row 2 columns H to N:
- I only want to sum the totals in row 2 columns H to N with/from the data in rows 3-5 columns H-N if Column E for any specific row is "High" or "Very High"
- So a specific example - J2 would be 0.5 if E5's dropdown was "low"
- Or, J2 would be 1.0 if E4 and E5 were "high" or "very high"

Thank you in advance!
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
