I’m working on a Google Sheets project and I need some help. I’ve set up a dropdown menu with Yes and No options. What I want to do is add up the values in a different column, but only for the rows where ‘Yes’ is selected in the dropdown. Here’s what my sheet looks like:
| Dropdown | Value |
|----------|-------|
| Yes | 10 |
| No | 5 |
| Yes | 15 |
| No | 8 |
| Yes | 12 |
Is there a formula I can use to automatically sum the ‘Value’ column only when ‘Yes’ is picked in the ‘Dropdown’ column? I tried a few things but couldn’t get it to work. Any tips or suggestions would be really helpful. Thanks!
I’ve encountered this scenario in my spreadsheets before. The SUMIF function is indeed the way to go, but let me offer an alternative approach that might be useful in more complex situations. You could use an array formula like this:
=SUM(FILTER(B2:B, A2:A=“Yes”))
This formula first filters the Value column based on the ‘Yes’ condition in the Dropdown column, then sums the results. It’s particularly handy if you need to apply multiple conditions or work with larger datasets.
Remember to press Ctrl+Shift+Enter when entering this formula, as it’s an array formula. This method offers more flexibility for future modifications to your sheet. Hope this adds another tool to your spreadsheet arsenal!
hey there, surfingwave! i’ve got a quick trick for ya. try this formula:
=SUMIF(A:A,“Yes”,B:B)
it’ll add up all the values in column B where column A says “Yes”. super easy! just make sure ur dropdown entries are exactly “Yes” (caps matter). lemme know if u need more help!
I’ve tackled a similar challenge in my work, and I found a solution that might help you out. You can use the SUMIF function to accomplish this task. Assuming your data starts in row 2 and the Dropdown column is A and the Value column is B, the formula would look like this:
=SUMIF(A2:A, “Yes”, B2:B)
This tells Google Sheets to sum the values in column B, but only when the corresponding cell in column A contains “Yes”. It’s a powerful function that can save you a lot of manual work.
One tip from my experience: make sure your dropdown values are consistent. Sometimes hidden spaces or capitalization differences can throw off the results. If you’re having trouble, double-check that all your “Yes” entries are exactly the same.
Hope this helps! Let me know if you need any clarification on implementing this in your sheet.