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 VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.