![]() |
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