[phpBB Debug] PHP Warning: in file [ROOT]/ext/tapatalk/tapatalk/event/main_listener.php on line 282: Undefined array key "app_rebranding_id"
[phpBB Debug] PHP Warning: in file [ROOT]/ext/tapatalk/tapatalk/event/main_listener.php on line 283: Undefined array key "app_url_scheme"
[phpBB Debug] PHP Warning: in file [ROOT]/ext/tapatalk/tapatalk/event/main_listener.php on line 284: Undefined array key "app_icon_url"
[phpBB Debug] PHP Warning: in file [ROOT]/ext/tapatalk/tapatalk/event/main_listener.php on line 285: Undefined array key "app_name"
[phpBB Debug] PHP Warning: in file [ROOT]/ext/tapatalk/tapatalk/event/main_listener.php on line 287: Undefined array key "app_alert_message"
[phpBB Debug] PHP Warning: in file [ROOT]/ext/tapatalk/tapatalk/event/main_listener.php on line 289: Undefined array key "app_android_id"
[phpBB Debug] PHP Warning: in file [ROOT]/ext/tapatalk/tapatalk/event/main_listener.php on line 290: Undefined array key "app_android_description"
[phpBB Debug] PHP Warning: in file [ROOT]/ext/tapatalk/tapatalk/event/main_listener.php on line 291: Undefined array key "app_banner_message_android"
[phpBB Debug] PHP Warning: in file [ROOT]/ext/tapatalk/tapatalk/event/main_listener.php on line 294: Undefined array key "app_ios_id"
[phpBB Debug] PHP Warning: in file [ROOT]/ext/tapatalk/tapatalk/event/main_listener.php on line 295: Undefined array key "app_ios_description"
[phpBB Debug] PHP Warning: in file [ROOT]/ext/tapatalk/tapatalk/event/main_listener.php on line 296: Undefined array key "app_banner_message_ios"
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4150: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3035)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4150: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3035)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4150: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3035)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4150: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3035)
Foros Ingeniería Civil • Ayuda con sumatoria con Excel
Página 1 de 1

Ayuda con sumatoria con Excel

Publicado: Sab Sep 03, 2016 8:30 pm
por Alejandro_Salgado
Buen día.


El problema consiste en lo siguiente:

¿alguien que conozca una función para resolver una suma de esta forma? :

(7*1) + (7*2) + (7*3) + (7*4) = 70

donde yo pueda indicar que el limite es 4, o algún otro que necesitara establecer.

Saludos.

Re: Ayuda con sumatoria con Excel

Publicado: Mié Sep 07, 2016 11:38 am
por Ing. Luna
LA VERDAD NO SE ME OCURRE ALGUNA FUNCIÓN O NO LA SE DESDE EXCEL PARA HACER LO QUE PIDES, PERO DE FORMA PRACTICA Y DENTRO DEL MISMO PROGRAMA PUEDES TU PROPONER UNA FORMULA PARA RESOLVERLO, ADJUNTO UN ARCHIVO CON DEMOSTRACIÓN, ACLARO QUE SOLO LLEGUE HASTA LA FILA 10,000 TU PUEDES EXTENDER LA FORMULA HASTA DONDE LA NECESITES. FINALMENTE EL RESULTADO VARIARA DE ACUERDO A TU VALOR BASE Y EL VALOR LIMITE QUE LE QUIERAS APLICAR. SALUDOS¡¡¡