Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Two search arguments in array formula
Hello,
With help of this forum I created this array formula: {=SUM(--(FREQUENCY(IF((S_Shop_events="x")*(Event="5S"),ROW (S_Shop_events)),ROW(S_Shop_events))0))} Which basically states: count all the €œx€ in range called €˜S_Shop_events and count them in a cells where column is Event="5S". But what I need is to search in columns Event="5S" and Event="BECW". I was trying this formula: {=SUM(--(FREQUENCY(IF((S_Shop_events="x")*(Event={"5S",€ BECW€}),ROW(S_Shop_events)),ROW(S_Shop_events)) 0))} And this: {=SUM(--(FREQUENCY(IF((S_Shop_events="x")*OR((Event="5S"), (Event=€BECW€)),ROW(S_Shop_events)),ROW(S_Shop _events))0))} But they didnt work, the second version did returned result but incorekt. Any suggestions! Thank you, Guntars |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array function with more than 29 arguments | Excel Discussion (Misc queries) | |||
Array function with more than 29 arguments | Excel Discussion (Misc queries) | |||
Search for 2 true arguments and return true or false | Excel Discussion (Misc queries) | |||
2 way Vlookup - Creating array arguments from columns | Excel Discussion (Misc queries) | |||
How do I set up an array using countif for 2 separate arguments. | Excel Worksheet Functions |