Excel Forum

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.