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

See the attached. It relies on the FILTER function in the DATA tab.

Attached Files

Total Murders by Year Race.xlsx (10.1 KB, 11 views)