LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Andyd74
 
Posts: n/a
Default function to count the amount of cells depending on part of the cell entry


I want to count the number of "passes" from a column based on the
criteria that the adjacent column cells contain the letters "AB" at the
start of what ever is in the cell.

i.e.

column A column B
AB xxx pass
AB yyy pass
BC zzz pass
BC xxx fail
AB yyy fail

etc

Any ideas

thanks


--
Andyd74
------------------------------------------------------------------------
Andyd74's Profile: http://www.excelforum.com/member.php...o&userid=34013
View this thread: http://www.excelforum.com/showthread...hreadid=545414

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
UDF is updateing cells on another sheet with count from current sheet. John Excel Discussion (Misc queries) 3 March 20th 06 03:58 PM
How do I compare the entry in one cell against all other cells Micki Excel Discussion (Misc queries) 1 February 10th 06 02:46 AM
Cell Count bombayterror New Users to Excel 2 January 21st 06 09:33 PM
Changing cell colour depending on another cells value... Web master Excel Discussion (Misc queries) 3 January 10th 06 12:30 PM
Auto fill multiple cells depending on single cell value henrat Excel Worksheet Functions 2 November 28th 05 04:59 AM


All times are GMT +1. The time now is 03:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"