Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 04-18-2017, 03:20 PM
Logit Logit 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 2007
Expert
 
Join Date: Jan 2017
Posts: 408
Logit will become famous soon enoughLogit will become famous soon enough
Default

See the attached. It relies on the FILTER function in the DATA tab.
Attached Files
File Type: xlsx Total Murders by Year Race.xlsx (10.1 KB, 5 views)
Reply With Quote
Reply

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 12:18 PM.


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