Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting each time text appears in range???
Hi all, is there a function for counting the instances of text in a range of cells?, if i wanted to put a formula in A1000 that looked at the range(A2:A999) how would i get it to check if text exists if so count 1 if 2 instances of text exist count 2 and so on so if every cell had text in it i would end up with a figure of 997 in A1000. is this possible? regards, Simon -- Simon Lloyd ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708 View this thread: http://www.excelforum.com/showthread...hreadid=550270 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting each time text appears in range???
Hi Simon,
Try: =SUM(IF(ISTEXT(A2:A999),1,0)) as an array formula - entered with <Ctrl-Shift-Enter, instead of <Enter. Cheers -- macropod [MVP - Microsoft Word] "Simon Lloyd" wrote in message ... Hi all, is there a function for counting the instances of text in a range of cells?, if i wanted to put a formula in A1000 that looked at the range(A2:A999) how would i get it to check if text exists if so count 1 if 2 instances of text exist count 2 and so on so if every cell had text in it i would end up with a figure of 997 in A1000. is this possible? regards, Simon -- Simon Lloyd ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708 View this thread: http://www.excelforum.com/showthread...hreadid=550270 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting Text to Time format of XX:XX | Excel Discussion (Misc queries) | |||
Text to time convert | Excel Discussion (Misc queries) | |||
convert time imported as text to time format for calculations | Excel Worksheet Functions | |||
How can I display a cell range in a text box in excel? | Excel Discussion (Misc queries) | |||
counting a cell range within a range | Excel Worksheet Functions |