Hi!

You're summary table is setup in such a way that the last criteria "<120"
would need a separate formula since there is no upper boundary beyond 120.

Assume:

Name Age

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

Is on Sheet1 in the range A1:B10. A1 and B1 are the headers: Name, Age. A2
and B2 are empty and the data starts in A3:B3

On Sheet2.....

A1:F1 are the headers: Name,28,50,70,100,120

You should get rid of the "<".

Sheet2 A3:A6 are the listed names: Dave, Jenny,Mike ,Craig

In Sheet2 B3 enter this formula and copy across to E3:

=SUMPRODUCT(--(Sheet1!$A$3:$A$10=$A3),--(Sheet1!$B$3:$B$10=B$1),--(Sheet1!$B$3:$B$10<C$1))Enter this formula in F3:=SUMPRODUCT(--(Sheet1!$A$3:$A$10=$A3),--(Sheet1!$B$3:$B$10=F$1))Now, select the range B3:F3 and copy down to row 6.Biff"Paul" wrote in ... Hi my name is Paul and I am agonising over a data/formual problem. I havethe 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 followingheadings 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 morethan 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