Question

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

Answer 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

Top Q&A For: How to use Excel count function(formula) on sep...

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

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

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

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

How to Separate First Names and Last Names Into Separate Fields in a Microsoft Excel List?

If you work with spreadsheets and get a spreadsheet with first and last names combined, you know you cannot sort by last names. Sorting by the field with both first and last combined is of no use. ... Read More »
http://www.wikihow.com/Separate-First-Names-and-Last-Names-Into-Separate-Fields-in-a-Mi...


feedback
loading