| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating cells with text only
I have a spreadsheet with branches and survey answers to calculate. I want to only count the cells containing text in a certain range for each branch. The formula I'm trying to use is =counta(if(a2..k58="Port Malabar",j2..k58)). I keep getting a value error. I appreciate anyone's help with this. -- Cissy ------------------------------------------------------------------------ Cissy's Profile: http://www.excelforum.com/member.php...o&userid=20107 View this thread: http://www.excelforum.com/showthread...hreadid=561086 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't see text in cells | Excel Discussion (Misc queries) | |||
| Cells within a list to display a certain text but have different v | Excel Discussion (Misc queries) | |||
| Summing cells that contain numbers and text | Excel Discussion (Misc queries) | |||
| vlookup on large text in cells | Excel Worksheet Functions | |||
| Text shown up in other cells everytime a text is entered in 1 cell | Excel Discussion (Misc queries) | |||
Threaded Mode
