Difference between revisions of "OOoES/Traduccion/Calc: Funcion SUMA.PRODUCTO"
From Apache OpenOffice Wiki
< OOoES
m |
|||
| Line 8: | Line 8: | ||
=== Ejemplo: === | === Ejemplo: === | ||
| + | |||
Matrices: | Matrices: | ||
| Line 27: | Line 28: | ||
|} | |} | ||
| + | |||
| + | <tt>''' =SUMA.PRODUCTO(A1:B2;C1:D2) '''</tt> | ||
| + | :Devuelve 20. | ||
{| class="wikitable" | {| class="wikitable" | ||
| Line 45: | Line 49: | ||
|} | |} | ||
| − | <tt>''' SUMA.PRODUCTO(A1: | + | |
| − | :Devuelve | + | ''' Ejemplo:''' |
| + | {| class="wikitable" | ||
| + | |- | ||
| + | ! | ||
| + | ! A | ||
| + | ! B | ||
| + | ! C | ||
| + | ! D | ||
| + | |||
| + | |- | ||
| + | !1 | ||
| + | |2 | ||
| + | |3 | ||
| + | |4 | ||
| + | |5 | ||
| + | |||
| + | |- | ||
| + | !2 | ||
| + | |6 | ||
| + | |7 | ||
| + | |8 | ||
| + | |9 | ||
| + | |||
| + | |- | ||
| + | !3 | ||
| + | |10 | ||
| + | |11 | ||
| + | |12 | ||
| + | |13 | ||
| + | |||
| + | |} | ||
| + | |||
| + | |||
| + | <tt>'''=SUMA.PRODUCTO(A1:B3;C1:D3) '''</tt> | ||
| + | :Devuelve 397 | ||
| + | |||
| + | ===Vea También=== | ||
| + | [[OOoES/Traduccion/Calc: Funcion SUMAX2MASY2|SUMAX2MASY2]], [[OOoES/Traduccion/Calc: Funcion SUMAX2MENOSY2|SUMAX2MENOSY2]], [[OOoES/Traduccion/Calc: Funcion SUMAXMENOSY2|SUMAXMENOSY2]] | ||
| + | |||
| + | '''[[OOoES/Traduccion/Calc: Funciones Matriz|Funciones Matriz]]''' | ||
[[Category:OldES]] | [[Category:OldES]] | ||
Latest revision as of 18:12, 7 December 2012
SUMA.PRODUCTO
Devuelve la suma de los productos de los argumentos de las matrices suministradas.
Sintaxis:
SUMA.PRODUCTO(Matriz_1; Matriz_2...Matriz_3)
- Donde Matriz_1...Matriz_30 son hasta 30 matrices cuyos argumentos se desea multiplicar.
Ejemplo:
Matrices:
| A | B | |
|---|---|---|
| 1 | 1 | 2 |
| 2 | 4 | 3 |
=SUMA.PRODUCTO(A1:B2;C1:D2)
- Devuelve 20.
| C | D | |
|---|---|---|
| 1 | 2 | 2 |
| 2 | 2 | 2 |
Ejemplo:
| A | B | C | D | |
|---|---|---|---|---|
| 1 | 2 | 3 | 4 | 5 |
| 2 | 6 | 7 | 8 | 9 |
| 3 | 10 | 11 | 12 | 13 |
=SUMA.PRODUCTO(A1:B3;C1:D3)
- Devuelve 397