I have a name column and the several columns with Yes in those fields. I want to calculate the number of Yes for each name. I have inserted the data in a table. I created a sumif column for the total. I am going to be added in new columns. As I add in the columns I want that column to be included in the total. How do I get the added column in the table to be added in the total?

Attached Files

book2.xlsx (10.4 KB, 11 views)