Excel Forum
Similar Content
Count The Number of Words in a Cell or Range of Cells in Excel - With User-Specified Delimiter / Separator - UDF
Macro: UDF to count the number of words in a cell or range with a user-specified delimiter. ...
Return the Min or Max Value Using a Lookup in Excel - INDEX MATCH
Tutorial: Find the Min or Max value in a range and, based on that, return a value from another rang...
Display Filter Arrows in a Table or Data Set in Excel - AutoFilter
Macro: This free Excel macro allows you to apply filter settings to a data set, list, or range of...

Excel Magic Trick 711: Count Employees in a given County Based on Zip Code SUMPRODUCT COUNTIF

See how to use the SUMPRODUCT and COUNTIF functions together to count how many employees live in a county with many zip codes based on an employee list of all zip codes (in county and not in county). Array formula.

Download file: http://people.highline.edu/mgirvin/ExcelIsFun.htm

Got a Question? Ask it Here in the Forum.