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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculating cells with text only
Cissy wrote:
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. Hi Cissy, First of all I don't understand what you mean for: a2..k58 if you mean the range from A2 to K58, it should be: A2:K58 then you have to array enter your formula, i.e. press simultaneously Ctrl + Shift + Enter; so your formula should be: =counta(if(a2:k58="Port Malabar",j2:k58)) array entered, as described above. Instead, you could use a COUNTIF formula like this: =COUNTIF(a2:k58,"Port Malabar") -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
Reply |
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) |