Excel Forum
Similar Content
Determine if Cells Contain a Specific Value in Excel
Tutorial: Find if a cell or range of cells contains a specific value in Excel. This method can be us...
OFFSET Function in Excel
Tutorial: The OFFSET function in Excel returns a cell or range reference that is a specified number...
Sum a Range with Errors in Excel
Tutorial: How to sum a range of cells that contains errors. This requires an array formula, so it w...

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.