ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formula Problem (https://www.excelbanter.com/excel-discussion-misc-queries/245866-formula-problem.html)

Paul Black

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


All times are GMT +1. The time now is 08:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com