CountIf? With multiple Criteria.

[Tedmando]

›I am trying to use some raw data and organize it into a chart.

This is how the Raw Data Looks

1) "1" means they have been validated, and is the first criteria that they need to meet in order to be counted.
2) Then I want to take the raw age and group it into ages. "16-24 yr olds." 3) Lastly I want to take the state and group it into a region. "West Coast"

This is how I want my chart looks like.

so for the west coast I want California and Oregon counted, and only if there is a "1" in the validation, and if it meets the age range.

I've tried Countifs, but I am having difficulty. Any help would be greatly appreciated!!

 

[barry houdini]

You can use COUNTIFS something like this

=SUM(COUNTIFS(A:A,">=16",A:A,"<=24",C:C,{"Oregon","California"},D:D,1))

 

[Tedmando]

You can use COUNTIFS something like this

=SUM(COUNTIFS(A:A,">=16",A:A,"<=24",C:C,{"Oregon","California"},D:D,1))

Thank you kind sir! That worked excellently.