Thread: function to count the amount of cells depending on part of the cell entry
View Single Post
  #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

Reply With QuoteReply With Quote