Formula Problem

  • Thread starter Thread starter Paul Black
  • Start date Start date
P

Paul Black

Good afternoon everybody,

I have this formula ...

=IF(G20=0,"",IF(OR(W$5=0,G20=0,S20=0)," ",IF(SUMPRODUCT(COUNTIF
($S20:$X20,W$5:AB$5))=5,IF(SUMPRODUCT(COUNTIF($S20:$X20,AC$5))
=1,"5+","5"),SUMPRODUCT(COUNTIF($S20:$X20,W$5:AB$5)))))

.... which works very well.
I would like to change it so that if the AC$5 part applies to matched
zero, one, two, three, four, five (done) and six applies it puts a +
next to it like it does at present for the five.

Thanks in Advance,
Paul
 
I am not sure this is what you want

instead of that 1 replace it as
row(A1)
now copy the formula down


to understand the logic do an experiment
in an empty cell type
=row(A1)
it will give 1
copy this down in the same column
the results will 2,3,4,5 etc.

mine is windows xp excel 2002
 
Back
Top