Conditional Count

[Spymaster1]

I have a spreadsheet which categorizes safety incidents into 4 levels of harm 1,2,3,4. I wish to analyze content by level of harm. in essence I want to be able to perform a count that gives me total number of incidents at harm level 1, harm level 2, etc.
the cells I wish to perform this function on are S17, S20, S23, S26, S29. Is it possible to create a formula that performs a count based on the cell content? This is only include the cell in the count if it contains a specific value. I hope I have explained myself adequately.

Many thanks

Craig

 

[ps1]

try:

=countif(a:a,"1")

you could have a validated list from 1-4 that the countif to reference to or have 4 seperate formuales.

 

[sdruley]

Pivot Tables can be of great value in stratification studies.

04.01.2013-09.24.53 - sdruley's library