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.