Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
problem with formula | Excel Discussion (Misc queries) | |||
formula problem | Excel Discussion (Misc queries) | |||
Formula Problem | Excel Worksheet Functions | |||
Formula problem. | Excel Worksheet Functions | |||
formula problem | New Users to Excel |