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, 9 views)

Perhaps try =COUNTIF(C2:INDEX(2:2,MATCH(REPT("Z",255),2:2)),"Y es")

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

When you add a column, the formula in A2, which is now =countif(c2:g2,"Yes"), changes automaticly in =countif(c2:h2,"Yes") .
The underlying cells in column A change accordingly.

Thank you.