How do I sort data with multiple conditions?

[CorinDarksoul]

I am trying to count the frequency of a value occurring if 2 conditional
statements are met. Each conditional statementis in a seperate column. I
have tried nesting an if statement inside of a countif; using if(and
statements ect. and these don't seem to work.

My problem is that I have 12 sites, with several types of injuries they
report. My sites are in one column, and the injuries in another. I need to
beable to see how many injuries of one type there are at a specific site. So
my formula would look through the site column and count count how many type a
injuries there were and return that number to me. I would then change the
formula to fit each site/injury, which should be easy to do once I have the
formula.

 

[Franz Verga]

If I understand well your problem, you can solve this way:

select a cell inside your range, then from menu Data, Sort, choose the
condition of sorting most suitable to you and if you have or not a header
row.

Nel post *CorinDarksoul* ha scritto:

I am trying to count the frequency of a value occurring if 2
conditional statements are met. Each conditional statementis in a
seperate column. I have tried nesting an if statement inside of a
countif; using if(and statements ect. and these don't seem to work.

My problem is that I have 12 sites, with several types of injuries
they report. My sites are in one column, and the injuries in
another. I need to beable to see how many injuries of one type there
are at a specific site. So my formula would look through the site
column and count count how many type a injuries there were and return
that number to me. I would then change the formula to fit each
site/injury, which should be easy to do once I have the formula.

--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy