Help with rewriting SUMIF formula

[Sean15]

Hello:

Formula in E5 is returning zero, but expected value is $1,850.00
Could you help me rewrite formula in E5?

Book1
	B	C	D	E
1	Age	Amount
2	120	>1200
3	65	>650
4	45	425
5				-
6			Expected value	1,850.00
Sheet1

Cell Formulas
Range	Formula
E5	E5	=SUMIF($B$2:$B$4,">=60",$C$2:$C$4)
E6	E6	=1200+650

Thank you so much
Sean

 

[Sean15]

Here is the new data layout.
There are blank cells in column B so formula in E5 (adapted from formula in post #8) is returning #VALUE!
Sometimes I am able to solve the little surprises but this time I am stumped.
Again, my apologies.

SUMIF formula.xlsx
	A	B	C	D	E
1	ID NO	Age	Amount
2	752412	>120	1200
3	752412	65	650
4	12542	65	425
5	12542		125	752412	#VALUE!
6				Expected result	1,850.00
Sheet1

Cell Formulas
Range	Formula
E5	E5	=SUMPRODUCT(--($A$2:$A$5=D5),--(--SUBSTITUTE($B$2:$B$5,">","")>=60),$C$2:$C$5)
E6	E6	=1200+650

 

[Peter_SSs]

Try

=SUMPRODUCT(--($A$2:$A$5=D5),--(--(0&SUBSTITUTE($B$2:$B$5,">",""))>=60),$C$2:$C$5)

 

[Sean15]

Thanks so much.
@Peter_SSs & @Scott Huish, your assistance has been invaluable.

Regards,
Sean

 

[Nalini1998]

Here is the new data layout.
There are blank cells in column B so formula in E5 (adapted from formula in post #8) is returning #VALUE!
Sometimes I am able to solve the little surprises but this time I am stumped.
Again, my apologies.

SUMIF formula.xlsx
	A	B	C	D	E
1	ID NO	Age	Amount
2	752412	>120	1200
3	752412	65	650
4	12542	65	425
5	12542		125	752412	#VALUE!
6				Expected result	1,850.00
Sheet1

Cell Formulas
Range	Formula
E5	E5	=SUMPRODUCT(--($A$2:$A$5=D5),--(--SUBSTITUTE($B$2:$B$5,">","")>=60),$C$2:$C$5)
E6	E6	=1200+650