Excel Formula Sum of Minimum Values

I need formula to get sum of values. Sample worksheet is Attached.

[TABLE="class: thin_grid"]

[tr]

[td]

v

[/td]

[TD="align: center"]A
[/TD]
[TD="align: center"]B
[/TD]
[TD="width: 133, bgcolor: #ECF0F0, align: center"]C
[/TD]

[/tr]

[tr]

[TD="bgcolor: #ECF0F0, align: center"]1
[/TD]
[TD="bgcolor: #FFFFFF"]Month
[/TD]
[TD="bgcolor: #FFFFFF"]SALE
[/TD]
[TD="bgcolor: #FFFFFF"]Value B or Max 250
[/TD]

[/tr]

[tr]

[TD="bgcolor: #ECF0F0, align: center"]2
[/TD]
[TD="bgcolor: #FFFFFF"]Jan
[/TD]
[TD="bgcolor: #FFFFFF"]227
[/TD]
[TD="bgcolor: #FFFFFF"]227
[/TD]

[/tr]

[tr]

[TD="bgcolor: #ECF0F0, align: center"]3
[/TD]
[TD="bgcolor: #FFFFFF"]Feb
[/TD]
[TD="bgcolor: #FFFFFF"]594
[/TD]
[TD="bgcolor: #FFFFFF"]250
[/TD]

[/tr]

[tr]

[TD="bgcolor: #ECF0F0, align: center"]4
[/TD]
[TD="bgcolor: #FFFFFF"]Mar
[/TD]
[TD="bgcolor: #FFFFFF"]510
[/TD]
[TD="bgcolor: #FFFFFF"]250
[/TD]

[/tr]

[tr]

[TD="bgcolor: #ECF0F0, align: center"]5
[/TD]
[TD="bgcolor: #FFFFFF"]Apr
[/TD]
[TD="bgcolor: #FFFFFF"]606
[/TD]
[TD="bgcolor: #FFFFFF"]250
[/TD]

[/tr]

[tr]

[TD="bgcolor: #ECF0F0, align: center"]6
[/TD]
[TD="bgcolor: #FFFFFF"]May
[/TD]
[TD="bgcolor: #FFFFFF"]503
[/TD]
[TD="bgcolor: #FFFFFF"]250
[/TD]

[/tr]

[tr]

[TD="bgcolor: #ECF0F0, align: center"]7
[/TD]
[TD="bgcolor: #FFFFFF"]Jun
[/TD]
[TD="bgcolor: #FFFFFF"]176
[/TD]
[TD="bgcolor: #FFFFFF"]176
[/TD]

[/tr]

[tr]

[TD="bgcolor: #ECF0F0, align: center"]8
[/TD]
[TD="bgcolor: #FFFFFF"]Jul
[/TD]
[TD="bgcolor: #FFFFFF"]368
[/TD]
[TD="bgcolor: #FFFFFF"]250
[/TD]

[/tr]

[tr]

[TD="bgcolor: #ECF0F0, align: center"]9
[/TD]
[TD="bgcolor: #FFFFFF"]Aug
[/TD]
[TD="bgcolor: #FFFFFF"]485
[/TD]
[TD="bgcolor: #FFFFFF"]250
[/TD]

[/tr]

[tr]

[TD="bgcolor: #ECF0F0, align: center"]10
[/TD]
[TD="bgcolor: #FFFFFF"]Sep
[/TD]
[TD="bgcolor: #FFFFFF"]403
[/TD]
[TD="bgcolor: #FFFFFF"]250
[/TD]

[/tr]

[tr]

[TD="bgcolor: #ECF0F0, align: center"]11
[/TD]
[TD="bgcolor: #FFFFFF"]Oct
[/TD]
[TD="bgcolor: #FFFFFF"]148
[/TD]
[TD="bgcolor: #FFFFFF"]148
[/TD]

[/tr]

[tr]

[TD="bgcolor: #ECF0F0, align: center"]12
[/TD]
[TD="bgcolor: #FFFFFF"]Nov
[/TD]
[TD="bgcolor: #FFFFFF"]775
[/TD]
[TD="bgcolor: #FFFFFF"]250
[/TD]

[/tr]

[tr]

[TD="bgcolor: #ECF0F0, align: center"]13
[/TD]
[TD="bgcolor: #FFFFFF"]Dec
[/TD]
[TD="bgcolor: #FFFFFF"]980
[/TD]
[TD="bgcolor: #FFFFFF"]2551
[/TD]

[/tr]

[tr]

[TD="bgcolor: #ECF0F0, align: center"]14
[/TD]
[TD="bgcolor: #FFFFFF"]Total
[/TD]
[TD="bgcolor: #FFFFFF"]5775
[/TD]
[TD="bgcolor: #FFFFFF"]5102
[/TD]

[/tr]

[/TABLE]

I need a formula in single cell to get the result as 5102

Re: Excel Formula Sum of Minimum Values

Sorry, December's value would be 250 and the total is 2801. I need a single formula to get the result 2801 without help of Column C.

Re: Excel Formula Sum of Minimum Values

Is it possible to put a formula without COUNTIF function. I need a formula which will take 250 instead of values greater than 250.

Re: Excel Formula Sum of Minimum Values

Thanks. This formula solve my problem. Is there any formula shorten then =SUM(IF(B2:B13<=250,B2:B13,250)) ?

Re: Excel Formula Sum of Minimum Values

Only for Brevity.