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

  • Thread starter Thread starter SSharp
  • Start date Start date
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?
 
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
 
You must log in or register to reply here.

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

vlookup? 2
How to I combine excel worksheets? 6
Function to add name of Sheet to a Column? 4
Prefilled Outlook Yes Voting Button response 0
min if horizontal 0
EXCEL - IF(IFERROR(VLOOKUP question 0
SUMIF() to add cells in non-contiguous ranges? (Excel 2003) 4
Searching on 2 columns and putting result in third column. 2

Back
Top