View Single Post
 
Old 04-18-2017, 01:07 PM
rachaels54 rachaels54 is offline Windows 10 Office 2016
Novice
 
Join Date: Apr 2017
Posts: 1
rachaels54 is on a distinguished road
Default 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
Reply With Quote