Sum Based On Certain

[varunwalla]

Need to sum if values are present in the cell. Now in D column if it has any values then should sum D column and F to G column

for e.g

in d2 the value is 990
in f2 the value is 1
in g2 the value is 1
in h2 the value is 1

and in i2 the value should be shown as 993

test.xlsx
	A	B	C	D	E	F	G	H	I	J
1	Name	QTY	TP	NTPAYIN	NTPAYOUT	T1	T2	T3	NAPBC	OUTPUT
2	CTI	5	198	990		1	1	1		993
3	TCI	10	3		30	1	1	1		not be calculated can be blank in i3
Sheet1

Cell Formulas
Range	Formula
D2	D2	=(B2*C2)
E3	E3	=(B3*C3)

 

[Fluff]

How about

=IF(D2="","",SUM(D2,F2:G2))

 

[varunwalla]

How about

=IF(D2="","",SUM(D2,F2:G2))

yes it works just changed the range upto h2

 

[Fluff]

You're welcome & thanks for the feedback.