I have 2 columns in Excel "yes" and "no" can I add them up?

S

SSharp

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

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
 
Top