Biff,
The column with 'falls' has numerous other classifications such as 'tears',
'skin', 'bruises' etc. I want a formual that will count only falls for lets
say the 100 hall. Thanks for your help.

"Biff" wrote:

> What result would you expect from this sample:
>
> fall..........100 hall
> fall..........100 hall
> full..........100 ball
> fall..........200 hall
> fall..........200 hall
> fall..........300 hall
>
> Biff
>
> "FSmitty" <FSmitty@discussions.microsoft.com> wrote in message
> news:37A54461-CD5A-411E-ABDF-7F12D4ADF707@microsoft.com...
> >I have two columns in a spreadsheet. One column has one word descriptions
> > e.g. falls, and the other column has the location e.g 100 hall. I want to
> > compile the number of falls for example that occurred on different halls
> > e.g
> > 100, 200, 300 halls. Remember that the column with descriptions has
> > several
> > descriptions but I just want falls.
>
>
>