Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 04-18-2017, 01:07 PM
rachaels54 rachaels54 is offline I need to count based on multiple criteria in multiple columns Windows 10 I need to count based on multiple criteria in multiple columns Office 2016
Novice
I need to count based on multiple criteria in multiple columns
 
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
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
I need to count based on multiple criteria in multiple columns 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 count based on multiple criteria in multiple columns 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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:35 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft