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

 

[Scott Huish]

Formula is fine. Take out the greater than symbols in cells C2:C3

 

[Sean15]

Hi:
Thank you. Formula has to be added to an executive report so I am not able to edit column C.

Sean

 

[Peter_SSs]

24 10 23.xlsm
	B	C	D	E
1	Age	Amount
2	120	>1200
3	65	>650
4	45	425
5				1850
Sum

Cell Formulas
Range	Formula
E5	E5	=SUMPRODUCT(--(B2:B4>=60),--SUBSTITUTE(C2:C4,">",""))

 

[Sean15]

@Peter_SSs, thank you very much.

 

[Peter_SSs]

Cheers. No problem.

 

[Sean15]

Hi,
There was an error in my sample data from post #1. The greater than symbol is in cells B2:B3. There is no greater than symbol in cells C2:C3. The expected result in E5 is still the same 1,850.00. Could you help rewrite formula? My apologies for the mix up.

 

[Scott Huish]

=SUMPRODUCT(--(--SUBSTITUTE(B2:B4,">","")>60),C2:C4)

 

[Sean15]

On men, I'm jinxed.
My live worksheet has several blank cells in column B so formula in post#8 is returning #VALUE!.
@Scott Huish, can we compensate for blank cells in column B?

Sean

 

[Peter_SSs]

So, what about you get your data completely worked out and then post a better, fully representative, set of sample and the expected results and explain again in relation to that new sample data?