View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] mitja.decman@fu.uni-lj.si is offline
external usenet poster
 
Posts: 3
Default countif, sumif, or whatever - counitg just some psecific values

This is a small table with data from a questionnaire about first job
position and before pension job position:

gender first job before pension job
m worker worker
m secretary boss
f boss boss
m secretary boss
f boss boss
f worker worker
f secretary secretary
m worker secretary

I want to make a table that would count workers, secretaries and
bosses for m-male and f-female separately for both questions,
something like this:
worker secretary boss
m first 2 2 0
pension 1 1 2
f first 1 1 2
pension 1 1 2

Which functions to use to get these counting?
Thanks
Mitja