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

Sum up data backward base on criteria

K

KIM Chanthan

Member
Hi,

Do you have any best and simple way to sum up the data backward base on the criteria.

Please view attached file for more detail.

Thanks,
 

Attachments

  • Sum up data backward.xlsx
    10 KB · Views: 3
Try,

In C14, copied across to D14 and down :

=SUMIFS(INDEX(B$3:Y$5,MATCH($B14,$A$3:$A$5,0),),B$2:Y$2,C$13,$B$1:$Y$1,"<="&$C$11)

Regards
Bosco
 

Attachments

  • Sum up data backward(1).xlsx
    11.4 KB · Views: 2
You must log in or register to reply here.
Back
Top