Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Uploaded on May 16, 2011
Download file: https://people.highline.edu/mgirvin/E... 1. See how to use SUMPRODUCT instead of SUMIF when external workbook references are used. 2. SUMPRODUCT can solve the problem of #VALUE! error for SUMIF when the external data source workbook is closed. 3. SUMIF, SUMIFS, COUNTIF, COUNTIFS, AVEARGEIF and AVERAGEIFS all will yield #VALUE! error when workbook closed. 4. See how to use SUMPRODUCT for adding, counting or averaging.