needed formula for conditional sum

[kamaruddinjnv]

PROBLEM WRITTEN IN PICTURE

 

[lrobbo314]

Book1.xlsx
	A	B	C	D	E	F	G	H	I	J	K
2			100	100	100	100	50	50	50
3			Sub-1	Sub-2	Sub-3	Sub-4	Sub-5	Sub-6	Sub-7
4										Total Max	Total Obtained
5	1	A	80	80	80	80	40			450	360
6	2	B			80	80	40	40	40	350	280
7	3	C	70	70		70	30	30		400	270
Sheet1

Cell Formulas
Range	Formula
J5:J7	J5	=SUMPRODUCT((C5:I5<>"")*($C$2:$I$2))
K5:K7	K5	=SUM(C5:I5)

 

[Ank1234]

Try this in cell J5 "=SUMIF($C5:$I5,">"&0,C$2:I$2)". Copy down

 

[kamaruddinjnv]

Try this in cell J5 "=SUMIF($C5:$I5,">"&0,C$2:I$2)". Copy down

Thanks Mr Ank1234, its works perfectly even formula is given in C2 : I2 cells. Thanks again.

 

[kamaruddinjnv]

Thanks Mr Irobbo314 for your nice solution but working only without formula in C2:I2 , when putting formula in C2:I2 its showing error.