display row based on two columns

[hnb_tor]

Hi, 

I have a table like shown below, I dont want to display rows when Regional Total Orders = 0 and Customer Total Orders > 0, but all other rows should be displayed. Could someone please help ? I tried the IF(AND(COND1, COND2), "True", "False) but I'm running into issues. 

Customer	Department	Region	Orders	Regional Total Orders	Customer Total Orders
A Corp	Sales	Asia	0	2	7	Don’t Display this Row
A Corp	Marketing	Asia	2	2	7	Display this Row
A Corp	R&D	Europe	5	5	7	Display this Row
B Corp	Sales	Americas	0	0	0	Display this Row
B Corp	Procurement	Americas	0	0	0	Display this Row
B Corp	Research	Europe	0	0	0	Display this Row
C Corp	Sales	Americas	0	0	24	Don’t Display this Row
C Corp	Marketing	Americas	0	0	24	Don’t Display this Row
C Corp	HR	Asia	10	24	24	Display this Row
C Corp	Finance	Asia	14	24	24	Display this Row

[lbendlin · Accepted solution]

Why should your first row be excluded? Regional Total Orders for A Corp Sales Asia is not 0.

[hnb_tor]

Thank you so much, yes the description was incorrect about the first row, but the solution worked perfect.