I need to count based on multiple criteria in multiple columns
Here is the breakdown:
I am doing an analysis of murders in the US from 2008-2014. More specifically by race
I have three colums with 5000 entires, Column A has multiple entries of years, either 2008, 2009, 2010, etc. column B has 4 criteria as the victims (black, white, asian, other), Column C has 4 criteria as the murder (black, white, asian, other). I am trying to count, the number of murders in 2008, committed by a white person, against another white person.
Example set answer should equal 2 (2 reported incidents of white on white murder in 2008)
A B C
2008 White White
2008 White White
2008 Black Asian
2010 Black White
2013 Asian Black
|