Users want a formula that can sum values based on a specific category selected from a dropdown, with the ability to live update as new data is entered.
I'm new to Google Sheets, and I'm having trouble applying the correct formula to find the sum in D2:D213, specifically for "Rejections" in the dropdown feature. I'm looking to organize my job applications throughout this process, and I'm not sure how to find the total of "rejections" in this column. Any advice or formulas I can try? (would be great if it were to live update as I enter more data in the future, but that's a want, not a need) I would also eventually like to do the same in the "websites" column to find which websites produce the most responses from recruiters, but I'm not sure how to tackle that. Any help would be appreciated! https://preview.redd.it/jcgltw1yzamg1.png?width=862&format=png&auto=webp&s=a27be3eea2c99f44e3fdc768b22989bed5a9eafc