Compare two sets of data

**Hollyoak08** · 03-09-2010, 05:32 AM

I have two sets of data that contain two companies sales targets. The data is as followed:
Data 1
Target Actual
Jan-06 12 13
Feb-06 12 14
Mar-06 31 30
Apr-06 10 11
May-06 15 14
Jun-06 15 13
Jul-06 15 16
Aug-06 54 55
Sep-06 9 10
Oct-06 12 11
Nov-06 13 11
Dec-06 8 7

Data2
Jan-06 14 13
Feb-06 12 11
Mar-06 35 33
Apr-06 10 12
May-06 15 14
Jun-06 15 13
Jul-06 15 12
Aug-06 54 57
Sep-06 9 12
Oct-06 12 13
Nov-06 13 8
Dec-06 8 7

I need to work out which company performed better. Each company has different targets so i need to no based on there targets who was better.

**zbor** · 03-09-2010, 05:40 AM

Next to Data1 you can do this: =AVERAGE(C2:C13/B2:B13) and comfirm with ctrl+shift+enter

same for other company with their ranges.. you'll get average percentage of Actual vs. Target

**Hollyoak08** · 03-09-2010, 05:45 AM

For data 1 my targets are in cell B5:B16 and actual are in cell C5:C16 and data 2 is in F5:F16 and actual is in G5:G16,how would i associate that formula with them cells

**zbor** · 03-09-2010, 05:54 AM

Just change values in formula and press ctrl+shift+enter
and you see brackets {formula} surround your formula... This brackets can not be entered manually. They must appear after you pres ctrl+shift+enter

=AVERAGE(C5:C16/B5:B16)

=AVERAGE(G5:G16/F5:F16)

Important: Target can not be zero