Thread: Formula Problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Black Paul Black is offline
external usenet poster
 
Posts: 394
Default Formula Problem

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