Problem with SUMIF formula

[Andrea]

I have a SUMIF formula which I am having difficulties with.

I have a column of ages, vacation time allowed and
vacation time used.

I am trying to write a formula to evaluate how much
vacation time is being used by age group, i.e., ages 20-
25, 25-30, etc.

I'm not sure how to compare within the SUMIF. For
instance, to sum all entries where the person is >=20 and
<=25. Here is what I've been using which is not working:

=SUMIF(Age,">=20 AND <=25",VacationAllowance)

(Age and VacationAllowance are Ranges)

I've also tried this, but I am not getting the correct
result:

=SUMIF(Age,">=20",VacationAllowance)+SUMIF
(Age,"<=25",VacationAllowance)

Could anyone provide some insight?

Thanks in advance.

 

[Bob Phillips]

An alternative along the lines you were trying

=SUMIF(Age,"<=25",VacationAllowance)-SUMIF(Age,"<20",VacationAllowance)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)