countif date range

J

joe

I want to find the occurence if it falls between a range

EG
Name Brth DT
Tom 1/1/2005
Bill 2/1/2005
Sam 4/1/2005
Wendy 6/1/2005

I want a count the number of people who have birth days before April 1st and
who Birth days after April 1st

How do I do it
 
R

RagDyer

Put the date you're looking to use as a break point into C1,

Then use this for *before* that date:

=SUMPRODUCT((B2:B10<>"")*(B2:B10<C1))


And this for *after* that date:

=SUMPRODUCT((B2:B10<>"")*(B2:B10>C1))


You realize, that Sam will *not* be counted at all, since he was not born
before *or* after April 1.

To *include* the date in the formula, just add an equal sign:
<=
=
Click to expand...
*BUT* don't add it to *both* formulas, otherwise you'll count Sam *twice*.

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
Top