# Calculate percentage change across two separate tables

1. ## Calculate percentage change across two separate tables

Hi all,

I've attached the workbook containing the problem I'd like to solve. The "Week1" and "Week2" tabs each contain a table of the same name that will be referenced. In the "% Change" Tab, I want to calculate the % Change from Week1 to Week2 for each value- e.g. in cell B2, I want to look up the corresponding value in Week1 and Week2, and calculate the percentage change.

The list of "Programs" in column A of "Week1" and "Week2" can change, as pictured in the example, so hopefully the formula could account for this.

Thanks so much for the help!

2. ## Re: Calculate percentage change across two separate tables

=IF(OR(Week1[@Subject1]=0,Week2=0),1,(Week2[@Subject1]-Week1[@Subject1])/Week1[@Subject1])

Enter in cell B2 sheet '% change', copy down then right.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1