How to use SUMPRODUCT to count days in a array of dates in Excel

I use the functions count and countif very frecuenly in my Excel sheets.

Few weeks ago, I needed to count the days of a array of dates and I couldn’t use other column to extract the day of this dates with the day() function.

For this reason I used the SUMPRODUCT funtion.

The SUMPRODUCT function description is: “Returns the sum of the products of corresponding ranges or arrays”, but SUMPRODUCT has more features.

One of this characteristics is count a range with a function inside the own function.

For Example: =SUMPRODUCT(–(DAY(D1:D10)=1))

This Example count all the days number “1” in the array D1:D10:

SUMPRODUCT is a very powerful function. You can read more information in:

Excel SUMPRODUCT Function
What is Excel SUMPRODUCT formula and how to use it? (In This post you can looking for the use of “–” simbol)

Enjoy!!!

Responder

Introduce tus datos o haz clic en un icono para iniciar sesión:

Logo de WordPress.com

Estás comentando usando tu cuenta de WordPress.com. Cerrar sesión / Cambiar )

Imagen de Twitter

Estás comentando usando tu cuenta de Twitter. Cerrar sesión / Cambiar )

Foto de Facebook

Estás comentando usando tu cuenta de Facebook. Cerrar sesión / Cambiar )

Google+ photo

Estás comentando usando tu cuenta de Google+. Cerrar sesión / Cambiar )

Conectando a %s