Formula Problem

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula is to long 8
Getting Rid of Zeros 2
Sumproduct Help Please 8
Use only cells with data in 8
expanding SUMPRODUCT 1
Conditional Formatting 4
Problem with If formula and concatenate "&" 1
A data validation question 1

Top