Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
A good day !
I have this function : =AND(COUNT(B1;B3;B5)<=1;COUNT(C1;C3;C3)<=1;COUNT(D 1;D3;D5)<=1;COUNT(E1;E3;E5)<=1;COUNT(F1;F3;F5)<=1) ; this function let me to know if every one of the 5 COUNT functions have the result the value <=1; (this is what I need !!, not to count everyone of the five count functions the value only <=1!!!; it must work like Count functions, not like a Countif function {Countif <=1 }) ; The last result of this this function I want to show me if all 5 Count functions result is <=1 ; This function work perfect for me , but I need very very strong a perfect equivalent for this function (why I need this , it's a long story ...) ,made with another functions . I get some variants , but them doesn't work ;(but I think the solution is somewhere here arround) : =COUNT(INDEX(MATCH(ROW(B4:AH83), {4,7,9,11,14,16,18,22,25,35,46,57,68,72,83},0)/ ISNUMBER(B4:AH83),0)) or =SUMPRODUCT(ISNUMBER(MATCH(ROW(B4:AH83), {4,7,9,11,14,16,18,22,25,35,46,57,68,72,83},0))* ISNUMBER(B4:AH83)) or =SUMPRODUCT(ISNUMBER(MATCH(ROW(B1:F5), {1,3,5},0))*(B1:F5<=1)) Can you help me to get a function which do the same thing like this function ? Thanks very much for your time . |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need A Solution To A Problem | Excel Discussion (Misc queries) | |||
sum if problem, trying to find best solution | Excel Discussion (Misc queries) | |||
Need solution to formula problem | Excel Discussion (Misc queries) | |||
Macro Solution for Link Problem? | Excel Worksheet Functions | |||
Pesky little problem with no solution? | Excel Worksheet Functions |