Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula problem | Excel Discussion (Misc queries) | |||
Formula = problem | Excel Programming | |||
Formula Problem need help | Excel Worksheet Functions | |||
formula problem | Excel Programming | |||
Formula problem | New Users to Excel |