I have a table that looks like the following:
Capture.JPG
I need to be able to count the number of unique OpUnits based on the Certification Level, FEMA Zone, and Status. For example, I need to be able to yield a resulting number of OpUnits that offer EMT-Paramedics in FEMA Zone 1 that are Active. Any help is greatly appreciated.
Look at COUNTIFS function
something like ......
=COUNTIFS(A:A,"=EMT-Paramedics",B:B,"=1",D:D,"=Active")
I would use a pivot table most likely, and possibly a powerpivot depending on exactly what I needed and how likely I was to reproduce this.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
Thanks for the reply John but I've tried variations of that. Problem is, this will indeed tell me that there are 130 EMT-Paramedics in Zone1 that are Active but it still does not give me a count of the unique OpUnits that are providing them.
MikeTron,
I tried a Pivot Table but couldn't quite figure out how to set it up so that it would result in the actual count of unique OpUnits based on the selections.
Use this formula with appropriate ranges to produce unique list of OpUnits
In this example input is Column A, output Column B
Put this in row 2 and enter with Ctrl+shift+Enter and copy down. You can then use COUNTIFS with entry as a criterion.
=INDEX($A$2:$A$20, MATCH(0, COUNTIF($B$1:B1, $A$2:$A$20), 0))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks