Jake wants to know, given an active date and an inactive date, how to count the customers that were active in a certain time period. The ones we want are highlighted in yellow. The formula is
=COUNT(D2:D21)-SUMPRODUCT(($C$2:$C$21>=D25)+($D$2:$D$21< =C25))
It’s easier to figure out who is not active during that date range and subtract it from the total. [...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2010/09/01/count-active-customers/
Posted
Sep 01 2010, 07:30 AM
by
Daily Dose of Excel