If And Question

[fandybow]

Hello,

I need help.

I have some criteria which consists of the following:

Name	Sales 2018	Sales 2019	Growth
A	155,471,000	218,313,000	62,842,000
B	0	160,174,100	0
C	201,561,300	0	0
D	335,127,700	246,324,000	-88,803,700
E	87,421,300	0	0
F	259,059,400	275,161,000	16,101,600
G	206,104,300	185,311,000	-20,793,300
H	195,334,400	0	0
I	203,839,100	196,328,000	-7,511,100
J	0	389,833,000	0
K	491,257,100	603,016,100	111,759,000
L	440,301,200	0	0
M	152,800,200	178,219,000	25,418,800
N	149,862,500	0	0

the idea is that : =IF(AND(C2>0,B2>0),C2-B2,0)

Any Ideas on how I can tackle this would be highly appreciated.

Thank you in advance for your time.

Fandy

[zhadrakas]

try it like this:

=IF(C2>0 AND B2>0,C2-B2,0)

regards

[SergeyMak · Accepted solution]

Try

SUM({<C2={">0"},B2={">0"}> } C2-B2)