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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
Click to expand...

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

HTH,
 
Back
Top