This formula is in cell D4.
=SUMPRODUCT((B4="aro")+(B4="aru")+(B4="ov")+(B4="und")+(B4="pao")+(B4="pau")+(B4="aco")+(B4="acu"),F4+G4)
As long as B4 contains any of the above text it works fine.
if B4 has any other text but the above I get a 0 (zero).
F4 and G4 contain numbers.
I do not want the 0 (zero) in cell D4 if the text in cell B4 is not what the formula is looking for.
There is probably an easier way to write the formula but I am only a little more than a beginner in excel.
If there is an easier way to do what I am trying to do please help.
Thank you.
irenesboy
=SUMPRODUCT((B4="aro")+(B4="aru")+(B4="ov")+(B4="und")+(B4="pao")+(B4="pau")+(B4="aco")+(B4="acu"),F4+G4)
As long as B4 contains any of the above text it works fine.
if B4 has any other text but the above I get a 0 (zero).
F4 and G4 contain numbers.
I do not want the 0 (zero) in cell D4 if the text in cell B4 is not what the formula is looking for.
There is probably an easier way to write the formula but I am only a little more than a beginner in excel.
If there is an easier way to do what I am trying to do please help.
Thank you.
irenesboy