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 news:E9858A46-B5AC-41E0-8D64-4E3C9996549F@microsoft.com
*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