• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Running total Employee wise from lowest value to Highest value

m9vukyem

Member
We have list of employees Lic Deductions in salary. we need to deduct their lic in salary as per their salary earnings. someone is getting salary lower than his total lic Deduction then we have to follow policy wise. please need a formula to get that sum value from lowest value highest value
 

Attachments

  • lowest to highst.xlsx
    15.1 KB · Views: 7
Like this?
[D]:= SUMPRODUCT((--(A3=$A$3:$A$142)),(--(C3>$C$3:$C$142)))
[E]:= SUMIFS($C$3:$C$142,$A$3:$A$142,A3,$D$3:$D$142,"<="&D3)
 

Attachments

  • lowest to highst.xlsx
    18.2 KB · Views: 8
Back
Top