Sum of Calculation in single Cell

  • Re: Sum of Calculation in single Cell


    Hi GIRISHBISHT
    With the smaller record sets its better to generate a table and write the request with in the thread.
    Or at least explain the request in the thread
    [table="class:thin_grid"]

    [tr][td]

    v

    [/td]


    [td="bgcolor:#ECF0F0, align:center,width:64"]A[/td]
    [td="bgcolor:#ECF0F0, align:center,width:64"]B[/td]
    [td="bgcolor:#ECF0F0, align:center,width:110"]C[/td]
    [td="bgcolor:#ECF0F0, align:center,width:62"]D[/td]

    [/tr][tr]

    [td="bgcolor:#ECF0F0, align:center"]1[/td]
    [td="bgcolor:#D9D9D9, align:LEFT"][COLOR="#000000"]Month[/COLOR][/td]
    [td="bgcolor:#D9D9D9, align:LEFT"][COLOR="#000000"]SALE[/COLOR][/td]
    [td="bgcolor:#D9D9D9, align:LEFT"][COLOR="#000000"]Value B or Max 250[/COLOR][/td]
    [td="bgcolor:#D9D9D9, align:LEFT"][COLOR="#000000"]Tax[/COLOR][/td]

    [/tr]


    [tr]

    [td="bgcolor:#ECF0F0, align:center"]2[/td]
    [td="bgcolor:#FFFFFF, align:LEFT"][COLOR="#000000"]Jan[/COLOR][/td]
    [td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]227[/COLOR][/td]
    [td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]227[/COLOR][/td]
    [td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]4[/COLOR][/td]

    [/tr]


    [tr]

    [td="bgcolor:#ECF0F0, align:center"]3[/td]
    [td="bgcolor:#FFFFFF, align:LEFT"][COLOR="#000000"]Feb[/COLOR][/td]
    [td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]594[/COLOR][/td]
    [td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]250[/COLOR][/td]
    [td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]5[/COLOR][/td]

    [/tr]


    [tr]

    [td="bgcolor:#ECF0F0, align:center"]4[/td]
    [td="bgcolor:#FFFFFF, align:LEFT"][COLOR="#000000"]Mar[/COLOR][/td]
    [td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]510[/COLOR][/td]
    [td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]250[/COLOR][/td]
    [td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]5[/COLOR][/td]

    [/tr]


    [tr]

    [td="bgcolor:#ECF0F0, align:center"]5[/td]
    [td="bgcolor:#FFFFFF, align:LEFT"][COLOR="#000000"]Apr[/COLOR][/td]
    [td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]606[/COLOR][/td]
    [td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]250[/COLOR][/td]
    [td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]5[/COLOR][/td]

    [/tr]


    [tr]

    [td="bgcolor:#ECF0F0, align:center"]6[/td]
    [td="bgcolor:#FFFFFF, align:LEFT"][COLOR="#000000"]May[/COLOR][/td]
    [td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]503[/COLOR][/td]
    [td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]250[/COLOR][/td]
    [td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]5[/COLOR][/td]

    [/tr]


    [tr]

    [td="bgcolor:#ECF0F0, align:center"]7[/td]
    [td="bgcolor:#FFFFFF, align:LEFT"][COLOR="#000000"]Jun[/COLOR][/td]
    [td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]176[/COLOR][/td]
    [td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]176[/COLOR][/td]
    [td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]4[/COLOR][/td]

    [/tr]


    [tr]

    [td="bgcolor:#ECF0F0, align:center"]8[/td]
    [td="bgcolor:#FFFFFF, align:LEFT"][COLOR="#000000"]Jul[/COLOR][/td]
    [td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]368[/COLOR][/td]
    [td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]250[/COLOR][/td]
    [td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]5[/COLOR][/td]

    [/tr]


    [tr]

    [td="bgcolor:#ECF0F0, align:center"]9[/td]
    [td="bgcolor:#FFFFFF, align:LEFT"][COLOR="#000000"]Aug[/COLOR][/td]
    [td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]485[/COLOR][/td]
    [td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]250[/COLOR][/td]
    [td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]5[/COLOR][/td]

    [/tr]


    [tr]

    [td="bgcolor:#ECF0F0, align:center"]10[/td]
    [td="bgcolor:#FFFFFF, align:LEFT"][COLOR="#000000"]Sep[/COLOR][/td]
    [td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]403[/COLOR][/td]
    [td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]250[/COLOR][/td]
    [td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]5[/COLOR][/td]

    [/tr]


    [tr]

    [td="bgcolor:#ECF0F0, align:center"]11[/td]
    [td="bgcolor:#FFFFFF, align:LEFT"][COLOR="#000000"]Oct[/COLOR][/td]
    [td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]148[/COLOR][/td]
    [td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]148[/COLOR][/td]
    [td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]3[/COLOR][/td]

    [/tr]


    [tr]

    [td="bgcolor:#ECF0F0, align:center"]12[/td]
    [td="bgcolor:#FFFFFF, align:LEFT"][COLOR="#000000"]Nov[/COLOR][/td]
    [td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]775[/COLOR][/td]
    [td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]250[/COLOR][/td]
    [td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]5[/COLOR][/td]

    [/tr]


    [tr]

    [td="bgcolor:#ECF0F0, align:center"]13[/td]
    [td="bgcolor:#FFFFFF, align:LEFT"][COLOR="#000000"]Dec[/COLOR][/td]
    [td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]980[/COLOR][/td]
    [td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]250[/COLOR][/td]
    [td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]5[/COLOR][/td]

    [/tr]


    [tr]

    [td="bgcolor:#ECF0F0, align:center"]14[/td]
    [td="bgcolor:#FFFFFF, align:LEFT"][COLOR="#000000"]Total[/COLOR][/td]
    [td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]5775[/COLOR][/td]
    [td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]2801[/COLOR][/td]
    [td="bgcolor:#FFFFFF, align:RIGHT"][COLOR="#000000"]56[/COLOR][/td]

    [/tr]


    [/table]
    sum of range D2 (to D13) [COLOR="#0000CD"]=ROUNDUP(C2*1.75%,0)[/COLOR]
    I need a formula in single cell to get the result as D14 = 56