Upload

Loading...

Excel Magic Trick 777.75: SUMPRODUCT Solves: SUMIF Won't Calculate From Closed Workbook

7,545 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

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.

Loading...

Advertisement
to add this to Watch Later

Add to

Loading playlists...