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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

bunch of "yes" or "no" entered in row, output 1 if a single yes 18
If formula with Yes or No 1
Excel Count from last specific text 3
Odd problem with formula counting Yes and No 5
would like help in Excess 2
need help with function and formulas 1
Nested Ifs in 2007 4
Match a cell to something in a column and return a YES 1

Top