How do I count based on conditions on two fields in data?
 

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?

How do I count based on conditions on two fields in data?
 

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?