#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
See the attached. It relies on the FILTER function in the DATA tab.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sum based on multiple criteria (one of the criteria is not unique) until a threshold is reached. | phillipsdp | Excel | 1 | 11-09-2016 12:53 AM |
Sorting large amounts of data based on multiple columns | bigmac4 | Excel | 2 | 08-23-2015 10:26 PM |
Hide rows in multiple columns based on zero values | Deane | Excel Programming | 19 | 06-23-2015 11:24 PM |
Link listbox (with multiple columns) to bookmark based on selection | dsjk9190 | Word VBA | 5 | 01-29-2015 11:28 PM |
I need to add multiple values based on multiple criteria in a cell not sure what to do | AUHAMM | Excel | 3 | 10-27-2014 09:11 PM |