Sum of the absolute value of differences of to matrix

[javierfbernal]

Hi, I'm new here.
I would like to know if there is a formula or formulation that calculate the sum of the absolute differences of two matrix
A B C
1 5 3 2
2 7 4 1
3 -2 -1 1
So, the answers I'm looking for in this example is sum of 2+1+1=4
I hope someone could help me.
Thanks,
Javier Bernal

 

[AAE]

Not sure this is what you meant, but if you want to sum A3:C3

{=SUM(ABS(A3:C3))}

This is an array formula and must entered using Ctrl + Shift + Enter keys in combination

 

[Robert Mika]

Hi, I'm new here.
I would like to know if there is a formula or formulation that calculate the sum of the absolute differences of two matrix
A B C
1 5 3 2
2 7 4 1
3 -2 -1 1
So, the answers I'm looking for in this example is sum of 2+1+1=4
I hope someone could help me.
Thanks,
Javier Bernal

Excel Workbook
	A	B	C	D
1	5	3	2	4
2	7	4	1
Sheet1

 

[javierfbernal]

Sheet1

*	A	B	C	D
*

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"></colgroup><tbody>
[TD="bgcolor: #cacaca, align: center"]1[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4[/TD]

[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1[/TD]

</tbody>

Spreadsheet Formulas

Cell Formula D1 =SUMPRODUCT(ABS(A1:C1-A2:C2)) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

It worked perfectly, thank you very much!

 

[Robert Mika]

It worked perfectly, thank you very much!

You are welcome.