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


    Why is December's value in column C not capped at 250? Cell C14 is simply =SUM(C2:C13).

    Ali :)


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules

  • 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.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!