SUM IF POSITIVE VALUE

[Jagat Pavasia]

Dear sir,
I want to total B2+G2+K2,
if B2+G2+K2 has positive amount, and answer in A2.

 

[etaf]

in A2 put
=IF( (B2+G2+K2 )>0, (B2+G2+K2 ),"")

 

[Jagat Pavasia]

in A2 put
=IF( (B2+G2+K2 )>0, (B2+G2+K2 ),"")

my answer in this sample is 125.

I mean do not calculation if negative value

 

[etaf]

are the entries in c,d,e,f,h,i,j
always blank
=SUMIF(B2:K2,">"&0)

Book1
	A	B	C	D	E	F	G	H	I	J	K
1
2	125	25					100				-25.22
3
Sheet1

Cell Formulas
Range	Formula
A2	A2	=SUMIF(B2:K2,">"&0)

or
=SUMIF(B2,">0")+SUMIF(G2,">0")+SUMIF(K2,">0")

Book1
	A	B	C	D	E	F	G	H	I	J	K
1
2	125	25					100				-25.22
3	125
Sheet1

Cell Formulas
Range	Formula
A2	A2	=SUMIF(B2:K2,">"&0)
A3	A3	=SUMIF(B2,">0")+SUMIF(G2,">0")+SUMIF(K2,">0")

 

[Jagat Pavasia]

are the entries in c,d,e,f,h,i,j
always blank
=SUMIF(B2:K2,">"&0)

Book1
	A	B	C	D	E	F	G	H	I	J	K
1
2	125	25					100				-25.22
3
Sheet1

Cell Formulas
Range	Formula
A2	A2	=SUMIF(B2:K2,">"&0)

I have text and amount in "C, D,E,F, H,I,J"

 

[etaf]

edited post - so may have missed
=SUMIF(B2,">0")+SUMIF(G2,">0")+SUMIF(K2,">0")

 

[Jagat Pavasia]

are the entries in c,d,e,f,h,i,j
always blank
=SUMIF(B2:K2,">"&0)

Book1
	A	B	C	D	E	F	G	H	I	J	K
1
2	125	25					100				-25.22
3
Sheet1

Cell Formulas
Range	Formula
A2	A2	=SUMIF(B2:K2,">"&0)

or
=SUMIF(B2,">0")+SUMIF(G2,">0")+SUMIF(K2,">0")

Book1
	A	B	C	D	E	F	G	H	I	J	K
1
2	125	25					100				-25.22
3	125
Sheet1

Cell Formulas
Range	Formula
A2	A2	=SUMIF(B2:K2,">"&0)
A3	A3	=SUMIF(B2,">0")+SUMIF(G2,">0")+SUMIF(K2,">0")

thank you dear...

 

[etaf]

you are welcome

maybe a better way , with 2021 , you have LET() FILTER() which may work - not sure - but other members may help