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

Calculation of percentage for each Category

dofrancis3

New Member
As you can see, I have two tables (Table_1 and Table_2) so, I'd like to calculate the percentage of each Category (table_1) according to each status (Table_2).

Bellow are the formula:

P1= ZD DIVIDE P1 (12-23 months) + P1 (24-59 months)

P3= Uim DIVIDE P3 (12-23 months) + P3 (24-59 months)

MC1= ZD DIVIDE MC1 (12-23 months) + MC1 (24-59 months)

MC2= Uim DIVIDE MC2 (12-23 months) + MC2 (24-59 months)
 

Attachments

  • My file.xlsx
    12.1 KB · Views: 2
Back
Top