array wildcard

  1. BetterBeef

    Using Wildcards in Array If Then Statements

    I have the following formula: ={IF($F$9:$F$25="STEER",SUMIF($C$9:$C$25,"*TONGUE*",$D$9:$D$25),0)} Unfortunately, the formula only runs the second part of the formula (the SUMIF part). It is essentially picking up all cells that have TONGUE in them and disregarding what variable is in Column...

Some videos you may like

This Week's Hot Topics