Thread: Function HELP!
View Single Post
  #1   Report Post  
Karen
 
Posts: n/a
Default Function HELP!

I have a range of cells (J3:P57) that the word "Reject"
may appear in. In an individual row, "Reject" may appear
in column J,M or P only. If it appears in any one of
those columns, I want to count the number of times it
appears. But it can only be counted once in each
row/record. If it appears in column J & P, count it
once. If it appears, in column J,M & P, count it once.

HELP!