Ayuda

jomi

New Member
Joined
Feb 13, 2012
Messages
3
Buenas,

Tengo excel 2003 y necesito realizar una suma

Tengo una columna con montos y a la lado una con la cantidad de días que pasaron a la fecha actual.

Yo necesito sumar solo los montos entre 0 y 30 días, de manera de que a medida que pasa el tiempo, no considere los montos cuyo plazo es mayor a 30 días y menores a 0 días.

Gracias!
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Asala42

Well-known Member
Joined
Feb 26, 2002
Messages
2,318
Pido disculpas si mi gramática suena apagado, estoy usando Google Translator para responder (Inglés al Español).

suponiendo:
Rango (A2: A100) contiene el número de días (0 - 30 y más)
Rango (B2: B100) contiene los números que desea sumar, cuando la columna A es es entre 0-30

=SUMPRODUCT(--(A2:A100>=0),--(A2:A100<=30),B2:B100)

(DoubleCheck el nombre de función para el español)

Si lo anterior no funciona para usted, es posible que desee publicar sus datos para que podamos ver lo que se está trabajando.
 

jomi

New Member
Joined
Feb 13, 2012
Messages
3
Thank you for your reply,

This is what I see:

=SUMPRODUCT(--(A2:A100>=0),--(A2:A100<=30),B2:B100)

If you would, I need to know what the "--" are...

If it works, i'll let you know, or i shall publish my excel so you can see what i wnat to do.

Thanks again.
 

Asala42

Well-known Member
Joined
Feb 26, 2002
Messages
2,318
If you would, I need to know what the "--" are...

Those are just a quick way to convert arrays of True/False entries to 1/0 numeric values.
 

Watch MrExcel Video

Forum statistics

Threads
1,132,685
Messages
5,654,746
Members
418,149
Latest member
amamiche67

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top