My data in Excel includes among other fields age and annual salary. I would
like to prepare a 2-way frequency table, without the use of pivot table,
giving a count of salary earners between 1000000 to 150000, 150001 to 200000
and 200001 and above for those aged between 20 and 30, 30 and 40, above 40.
Please help?

I think you will first of all have to create a table structure like

age 100000-150000 150000-200000
20-30
30-40
>40

Once you are done, then you can use IF to work out the expected output.

HTH,
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"Scott" wrote:

> My data in Excel includes among other fields age and annual salary. I would
> like to prepare a 2-way frequency table, without the use of pivot table,
> giving a count of salary earners between 1000000 to 150000, 150001 to 200000
> and 200001 and above for those aged between 20 and 30, 30 and 40, above 40.
> Please help?