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;E* 5)<=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 <=1!!!) Can you help me to get a function which do the same thing like this function ? I get some variants , but them doesn't work : =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)) Thanks very much for your time |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions |