How to sum the values on the basis of the dropdown option

1

I am having the following table where I have 3 options in dropdown. As per choice I want to show the sum in another table. Please find the example below

image
image1066×606 58 KB

2

@Video_by_Pro

3 Likes
3

Thank you so much. Also, the way you used the formula. Is there any alternative to if condition as I am having multiple conditions?

4

SwitchIf() might be an option for you. You can read about it here: https://coda.io/formulas#SwitchIf

Also, take note of the other types of formulas documented on that page, for future reference.