Need Help with Formula

[Amosbroker]

Ok, so I have this formula looking at multiple criteria and giving me back a unique number (frequency) I use an array formula. My if statement looked to be if certain cells where blank. Well now I need to run the same formula but do same if cells are blank OR have text that say none. How the heck do I add that additional criteria to my frequency array formula? HALP.

=SUM(IF(FREQUENCY(IF(1-(' Query A Notes'!F$2:F$1499=""),IF((' Query A Notes'!G$2:G$1499="")*ISNUMBER(SEARCH("Lifestyle",' Query A Notes'!K$2:K$1499))*ISNUMBER(SEARCH("Completed",' Query A Notes'!O$2:O$1499)),MATCH(' Query A Notes'!F$2:F$1499,' Query A Notes'!F$2:F$1499,0))),ROW(' Query A Notes'!F$2:F$1499)-ROW(' Query A Notes'!F$2)+1),1))

 

[Eric W]

I haven't parsed/tested your entire formula, but if you just want to change that one part, try:

=SUM(IF(FREQUENCY(IF(1-(' Query A Notes'!F$2:F$1499=""),IF(((' Query A Notes'!G$2:G$1499="")+(' Query A Notes'!G$2:G$1499="none"))*ISNUMBER(SEARCH("Lifestyle",' Query A Notes'!K$2:K$1499))*ISNUMBER(SEARCH("Completed",' Query A Notes'!O$2:O$1499)),MATCH(' Query A Notes'!F$2:F$1499,' Query A Notes'!F$2:F$1499,0))),ROW(' Query A Notes'!F$2:F$1499)-ROW(' Query A Notes'!F$2)+1),1))