PM01-0112: Operadores matemáticos: Totales y subtotales.

Operadores matemáticos

Total

[{"selector":"#anim-d29e807e-7d00-4a0c-b78d-9bcfe08e16a9","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-dfc1f23d-5054-451e-bc7a-6d781ab9c5d2","keyframes":{"transform":["translate3d(-114.8265%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-844624f0-83a9-423e-974c-a543548e46aa","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-cbb22439-4f1f-4558-a2de-6dadcae86973","keyframes":{"transform":["translate3d(-115.35948%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-c6e97f3d-a615-4b88-9670-81eb80ad0ed0","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-9fe3c991-3011-460a-b0a2-6158496991c0","keyframes":{"transform":["translate3d(261.53844%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-cf2f28f4-4f71-48b4-978c-f2cb0e23cc92","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ae96271c-5c93-407f-9a44-cfdd994065d6","keyframes":{"transform":["translate3d(100.00000%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-99d8dec2-554a-427f-a11c-54548adf2076","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-a67d141d-d50f-486a-9344-c067354ddaa9","keyframes":{"transform":["translate3d(124.36549%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-42fdee2c-f114-4626-ba97-f67f4c4c8f43","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-63bfd9d7-0dc7-453c-a32d-47ea1aaa04c4","keyframes":{"transform":["translate3d(257.69229%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-8a616d5b-8e88-4eb3-bb35-6534ba9dfe46","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-7e6b9c04-4940-402f-9281-a282cae417ca","keyframes":{"transform":["translate3d(100.00000%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f36fb01f-5f4d-41e3-b6f2-30a448c7c3a8","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-2e75c027-8be3-4b68-bb2a-9bee719d62d2","keyframes":{"transform":["translate3d(-335.00001%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-0adb89e2-26f0-48dd-bc8f-c8ccf26cc1be","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-fde21fca-6517-4b0c-8fce-1e71d3565491","keyframes":{"transform":["translate3d(-340.00004%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-719aadf4-ec6e-480a-937b-68180e74d941","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] Como vimos, la suma es el operador básico para calcular totales. Por tanto, las fórmulas serían las mismas: Fórmula =SUMA( rango ) Ejemplo: =SUMA(A1:A10) Función 1. Activa la función AUTOSUMA. 2. Selecciona el rango. 3. Presiona ENTER. Dot Dot

Subtotal

[{"selector":"#anim-0ee0d057-2c30-43c4-8774-fbd4e952dcc4","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f0125545-3e43-4c49-bf9e-bdd02e0dfae6","keyframes":{"transform":["translate3d(-115.45741%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-0339b199-dcf9-4505-9670-df6d837ed2cc","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-2dcc01cf-6f9b-4f17-ab8d-22248f956e97","keyframes":{"transform":["translate3d(-115.65495%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-d90d1066-cc7e-4faf-a35b-09f8e7eded62","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-429ba99d-784a-4230-b612-37f9bf1f324a","keyframes":{"transform":["translate3d(259.99997%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-828b71da-c5d0-4a03-aae3-b89fd20a4afe","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-7d9951de-bcc9-492d-b301-30c80c874810","keyframes":{"transform":["translate3d(99.34641%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ffb3b210-b4b1-4991-b0ee-febdd075e6b4","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-99eafd86-6505-432a-aa3f-5d2e480111e9","keyframes":{"transform":["translate3d(-149.64285%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-ef240edb-2836-4fcd-aefa-6a7b2fa3ab4d","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-d055e888-ad48-49ec-a9ab-d2b2090b2c68","keyframes":{"transform":["translate3d(-344.99987%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f84234db-33ef-435b-a362-d8adb3ada739","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-7093aeee-a9a2-4805-b1c9-1ba2b4dce6f5","keyframes":{"transform":["translate3d(99.34641%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-e1de0706-c1bd-4737-a066-3eb9b9bc8c32","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-4ed80613-da0e-4eaa-b415-5c89a15d6d9d","keyframes":{"transform":["translate3d(99.34641%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-8b4854ed-e792-4c63-bb26-5d9984ea59ab","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-cd36a052-23da-42d1-94b0-68f8dc96bbed","keyframes":{"transform":["translate3d(-161.06195%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-2d104a5e-4e41-4205-a1a7-3c37eef04e28","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-7afe1bdb-433a-4657-9c37-a454f502f606","keyframes":{"transform":["translate3d(126.14107%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-311af476-88e9-4890-aad2-b520cbc4504a","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-617c1cc0-d0a3-495e-b4c1-c2feaed807c8","keyframes":{"transform":["translate3d(-384.61545%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-efba6cf9-d047-45c8-b7d7-147d3b8d6846","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-413c9cac-9535-42f6-9aec-2c154eb23a62","keyframes":{"transform":["translate3d(-384.61545%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] Este operador se refiere a calcular segmentos del total basados en criterios seleccionados y/o filtrados por ti. Para ello puedes utilizar: Función SUBTOTAL Ejemplo: =SUBTOTAL(109, D1:D100) Dot =SUBTOTAL (fn, rango) SUMAR.SI Ejemplo: =SUMAR.SI(C1:C10, "Ventas", B1:B10) =SUMAR.SI (rango, “criterio”, rango) Burst Burst

Aprende cómo sacar el total y subtotal con el uso de filtros:

[{"selector":"#anim-2bf91133-fded-4184-a734-cd5d0c12ffca","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-7ce02f53-78e1-4b0b-bdda-466b8a1c6ba1","keyframes":{"transform":["translate3d(115.14195%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-9a3142e6-7d1d-46c0-956a-aa858dd69cfc","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-50d7ae2f-73cd-4ff3-b1c8-143642cc556b","keyframes":{"transform":["translate3d(-386.51686%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-a34d2e6b-0ca8-4d25-909c-57d4069ba943","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-bdef25c4-d3e6-4e6a-a19e-138411440055","keyframes":{"transform":["translate3d(-100%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-a2177957-ef54-44e2-bb77-7012f89321d6","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f4156ed0-8978-42ff-b112-161e00594c80","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] Aplica Arrow Arrow

[{"selector":"#anim-1830ecd0-f4b4-4eda-b0be-a3426d2b7bc9","keyframes":[{"offset":0,"transform":"translate3d(0, -166.2263%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.29,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.45,"transform":"translate3d(0, -46.74283556%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.61,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.71,"transform":"translate3d(0, -15.89123428%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.8,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.85,"transform":"translate3d(0, -5.967524170000001%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.92,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.96,"transform":"translate3d(0, -2.59313028%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":1,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"}],"delay":0,"duration":1400,"fill":"both"}]