Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Advanced SUMIF and SUMIFS Formulas.mp4

K2 Enterprises
5.08K subscribers
<__slot-el>
<__slot-el>
8.9K views 13 years ago
SUMIF and SUMIFS are two of Excel's best functions. Using these two functions, we can create formulas that add data, subject to one or more conditions. The primary difference in these two functions is that SUMIF allows only one condition to be evaluated, while SUMIFS allows up to 127 criteria to be evaluated; additionally, SUMIFS is only available in Excel 2007 or higher. In this tip, you will learn how to create advanced SUMIF and SUMIFS formulas that use cell references as the evaluation criteria. ...more
...more
Advanced SUMIF and SUMIFS Formulas.mp4
7Likes
8,983Views
2011Dec 21
SUMIF and SUMIFS are two of Excel's best functions. Using these two functions, we can create formulas that add data, subject to one or more conditions. The primary difference in these two functions is that SUMIF allows only one condition to be evaluated, while SUMIFS allows up to 127 criteria to be evaluated; additionally, SUMIFS is only available in Excel 2007 or higher. In this tip, you will learn how to create advanced SUMIF and SUMIFS formulas that use cell references as the evaluation criteria.

Follow along using the transcript.

K2 Enterprises

5.08K subscribers