CODEWITHSUNDEEP
excelexcel-formula
SantaSecrets
SantaSecrets

Reputation: 37

How to average the difference between 2 rows

No rush, this is pure curiosity as i've already finished the project but i want to know if there's a faster and cleaner way of averaging the difference between 2 rows.

I have 2 rows of data and i need to average the difference between the 2.

i.e.

Row1  5 6 8 4    
Row2  4 7 8 9

what i want to average

1,-1,0,-5

I tried this formula but failed.

{=AVERAGE(G26:U26-G28:U28)}

Upvotes: 0

Views: 307

Answers (2)

xidgel
xidgel

Reputation: 3145

Average of the differences is equal to the difference of the averages, so

=AVERAGE(Row1)-AVERAGE(Row2)

Hope that helps

Upvotes: 2

Scott Craner
Scott Craner

Reputation: 152450

You can use SUMPRODUCT:

=SUMPRODUCT(A1:D1-A2:D2)/COLUMNS(A1:D1)

enter image description here

Upvotes: 2

Related Questions