S SSharp Jun 8, 2009 #1 I replaced the yes with a 1 and the no's with a 2. Is it possible to keep the yes and no's and add up the columnx?
I replaced the yes with a 1 and the no's with a 2. Is it possible to keep the yes and no's and add up the columnx?
O Otto Moehrbach Jun 8, 2009 #2 What do you want to add up? Do you want to get the number of "Yes" and the number of "No"? If so, look in Help for CountIf. HTH Otto
What do you want to add up? Do you want to get the number of "Yes" and the number of "No"? If so, look in Help for CountIf. HTH Otto