GREATER OR EQUAL TO BUT LESS THAN Problem using Sumproduct
 

Does this work for you:

=SUMPRODUCT((DATA!C2:C2500=AA16)*(DATA!C2:C2500<= AA34)*(DATA!H2:H2500=18)*
(DATA!H2:H2500<=20))

?
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Iain Halder" wrote in message
...
Hi,

I have a list of ages of various patients from 18 to 65.

I'm breaking them into age groups and am using SUMPRODUCT.


=SUMPRODUCT((DATA!C2:C2500=AA16)*(DATA!C2:C2500<= AA34)*(DATA!H2:H2500=18<2
0))

C2:C2500 are date fields in format 01-Jan-05.
AA16 & AA34 are Start and Finish dates (months really).
H2:H2500 are the various ages.

AGE MONTH
<18 ?
18-20 ?
21-25 ?
26-30 ?
31-35 ?

... and so on up to age greater than 65

The problem is the =(age)<(age) bit ... how do I type this in
properly? I've tried a few variations which make sense to me but not,
alas, the computer.

Thank you for your help in this guys!

Iain

o< Rescued Cats & Kittens Needing Homes o<
o< www.celiahammond.org o<
o< www.cat77.org.uk o<