Question

 I want Excel to count how many cells contains "A" and how many "c" are under cells that contain "A"?

Answer one solution could be this:The cells that contain a and c are in column Aexample of data:abcbadbcbcabbdcdaccdbthen in column B , cell b1 insert the formula:=IF(NOT(ISERROR(SEARCH("a";A1)));1;"")and... Read More »
http://answers.yahoo.com//question/index?qid=20120902234144AAnd4Ga

Top Q&A For: I want Excel to count how many cells contains "...

Can Excel 2003 display the count of the cells and also sum of the cells together in status bar ?

From what I am aware of, not in the normal everyday way. From version 2003 or earlier, you may only see one of the aggregate values at a time in the Status Bar area, by right-clicking and choosing... Read More »
http://answers.yahoo.com//question/index?qid=20090704032914AAwNpmQ

How to use Excel count function(formula) on separate cells?

wow, these restrictions stink....is this for a class? at risk of upsetting the teacher...tell your teacher you want to make your formula work for all versions of Excel....and the 2 notes totally s... Read More »
http://answers.yahoo.com//question/index?qid=20120903190110AACbhYD

Anybody tell me how to copy cells automatically in MS excel just by selecting cells by arrow key?

I am not sure why you would want to alter the typical functioning of the arrow keys, it would not be a wise decision. There are many shortcut key combinations of selecting cells within MS-Excel: ... Read More »
http://answers.yahoo.com//question/index?qid=20090610165301AAaKnMN

Is cell membrane found in animal cells or plant cells?

The cell membrane, the outside casing or membrane of a cell, is found in both plant and animal cells. In fact, the cell membrane is a universal feature found in the cells of all living organisms. T... Read More »
http://www.answerbag.com/q_view/2243731


feedback
loading