BetterBeef
New Member
- Joined
- Mar 18, 2010
- Messages
- 42
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 F.
I need to set this up so that if "STEER" is in the cell in column F, it will sum it up, only if "Tongue" is in the description somewhere in column C.
Any clue what I am doing wrong?
={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 F.
I need to set this up so that if "STEER" is in the cell in column F, it will sum it up, only if "Tongue" is in the description somewhere in column C.
Any clue what I am doing wrong?