That is what I was looking for. Thank you!Hello, I think the formula you want in Cell F36 is =SUMIF(F4:F35,"Yes",E4:E35)
I inserted the code into cells C36 and D36 to add up the totals of their respective columns only if the data validation cell I inserted to the end was set to "yes".
Bookmarks