answersLogoWhite

0

You could use the COUNTIF function. If you have a column with the words yes and no in them, say in the cells from C2 to C25 and wanted to know how many contained yes and how many contained word, then you would use the following formulas:

=COUNTIF(C2:C25,"Yes")

=COUNTIF(C2:C25,"No")

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

What is the abbreviation for count in excel?

In Excel, the abbreviation for count is typically "COUNT." This function is used to count the number of cells in a range that contain numeric values. For counting non-empty cells regardless of type, the "COUNTA" function can be used.


What are some examples of Excel formulas?

formula's of excel =sum(+_/*) =count(if) =today() =now() by' (rubab)


How many functions are in Microsoft Excel 2007?

348, at my count


What is a function to find the number of values in cells?

In Excel is it COUNT.


What following functions was new in Excel 2007 sum ifs sum if count if or sum?

SUMIFS was new in Excel 2007.


What is the tabs in excel?

sum average max min count numbers


How do you use count if formulas on excel?

Count cells with numbers: COUNT Count cells with data: COUNTA Count blank cells: COUNTBLANK As an example: =COUNT(A1:A5) =COUNTA(A1:A5) =COUNTBLANK(A1:A5)


Can a person complete calculations in Microsoft Excel 2003?

Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.


Is Excel spreadsheet the same as Microsoft Excel?

Yes.


What is the AutoCalculate area that displays the number of cells containing numbers in the selected range?

The Auto Calculate area in Excel shows summary statistics, including the Count of Numbers. This displays the number of cells containing numerical values in the selected range.


Can Excel count the characters on a spreadsheet?

You can use the LEN function to count characters in a cell. You can also use it to count characters in multiple cells. You need to know how to do array formulas to do that.


What are some examples of excellence?

formula's of excel =sum(+_/*) =count(if) =today() =now() by' (rubab)

Trending Questions
What is a stable operating temperature for a Intel Celeron M 520 Processor. I use speedfan and it says at normal Operating temp it runs at 60 degrees. Under Load up to 75. BIOS is updated to latest.? What advantages and disadvantages does the tetrahedral kite have? How do you open cfg extention file? Can Software can be distributed on the Web? Is it better to buy books on programming or just look up the info online? When using a software suite documents can be transported or share between programs you could copy and paste from one document to another by using the process of what to share data between programs? How do you do keyboard art? Is an enhanced keyboard has 12 or more function keys along the top it also has two ctrl keys two alt keys and a set of arrow and additional keys between the typing area and the numeric keypad? WHICH printer produces the best quality graphics reproduction? What does LPT stand for? What is the set of instructions that tells a computer to initialize the motherboard how to recognize devices connected to the computer and to start the boot process.? Can you use your backup on a different computer? How is wireless networks implemented? Where can one purchase a wireless USB adapter? What function of ping command? Who creates and modifies computer programs? What size screwdriver do you need to open up a MacBook Pro late 2011? What is the main difference between animation and simulation? Will fanfictionnet send me lots of emails I sign up or send me spam? How do you unblock internet download manager?