Can you just subtract the sum of the prior columns of the same row? Ex: in
B2 you have a formula to find the number of Daves <28. In C2 you have a
formula to find the number of Daves <50. Append to that formula
-SUM(B$2:B2). Likewise in D2, you have a formula to find the number of Daves
<70; append -SUM(B$2:B3). And so on. So you're always calculating the
running total using the SUMIF, then subtracting out with SUM the total in
lower-age buckets.

"Paul" wrote:

Hi my name is Paul and I am agonising over a data/formual problem. I have the
folowing spreadsheet.

Name Age

Mike 28
Mike 96
Dave 52
Dave 12
Dave 68
Jenny 75
Craig 129
Craig 2

This sheet is summarised in another worksheet which has the following headings


Name <28 <50 <70 <100 <120

Dave
Jenny
Mike
Craig

What I am trying to do is insert formulas into the summary sheet under the
(<) colums which will count how many daves are 28 or older but not more than
50.
I use a formula which can count how many daves for examle are < a number,
but it cannot seem to return how many daves are < a number but less than
another number. the formula is SUMIF and I got it from the help menu.

I would be sooo stoked if you could help me with this..

Thanks