Excel Forum



Excel Magic Trick 723: COUNTIF Error With Workbook References, Use SUMPRODUCT Instead


Download file: http://people.highline.edu/mgirvin/ExcelIsFun.htm
Learn how to avoid errors with the COUNTIF function when using workbook references by using the SUMPRODUCT function.





Got a Question? Ask it Here in the Forum.