Upload

Loading icon Loading...

This video is unavailable.

Excel Magic Trick 777: SUMPRODUCT Function -- Basics To Advanced (14 Examples)

Sign in to YouTube

Sign in with your Google Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to like ExcelIsFun's video.

Sign in to YouTube

Sign in with your Google Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to dislike ExcelIsFun's video.

Sign in to YouTube

Sign in with your Google Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to add ExcelIsFun's video to your playlist.

Uploaded on Apr 19, 2011

Download file: https://people.highline.edu/mgirvin/E...

1. Learn how to use SUMPRODUCT function to multiply and then add arrays
2. Sales Example
3. Currency Example
4. Expected Return Example
5. Expected Portfolio Return Example
6. Converting TRUEs and FALSEs to ones and zeros using double negative
7. Boolean Logic and Boolean Math
8. Adding with 2 criteria for Excel 2003 and Earlier
9. Summing with 2 criteria for Excel 2003 and Earlier
10. Using YEAR function and SUMPRODUCT Function together to Count with two criteria
11. Using YEAR function and SUMPRODUCT Function together to Add with two criteria
12. Using TEXT function and SUMPRODUCT Function together to Count with three criteria
13. Using TEXT function and SUMPRODUCT Function together to Add with three criteria
14. Use SUMPRODUCT to calculate Weighted Average Cost

Loading icon Loading...

Loading icon Loading...

Loading icon Loading...

The interactive transcript could not be loaded.

Loading icon Loading...

Loading icon Loading...

Ratings have been disabled for this video.
Rating is available when the video has been rented.
This feature is not available right now. Please try again later.

Loading icon Loading...

Advertisement
Loading...
Working...
to add this to Watch Later

Add to