IF(D2="RED" AND C2="Plants",E2)
D2 is all text and C2 is all text, E2 is numbers.
I want to show E2 if there are red plants.  The spread sheet has 235 entries.

IF(D2="RED" AND(C2="Plants"),E2)
D2 is all text and C2 is all text, E2 is numbers.
I want to show E2 if there are red plants.  The spread sheet has 235 entries.

I can't make this work in either program.  I'd really like to make it work in LibreOffice Calc.