Скачать или смотреть How to Use SUM, SUMIF, SUMSQ, SUMIFS, SUMXMY2, SUMX2PY2, SUMX2MY2, SUMPRODUCT Formula in Excel(V016)

Learn how to use all SUM SERIES formulas and become a master of Excel

1) SUM = SUM(P2:P26)
2) SUMIF = SUMIF(L2:L26,E3,P2:P26)
3) SUMIFS = SUMIFS(P:P,L:L,E4,M:M,F4)
4) SUMPRODUCTS = SUMPRODUCT(($L$2:$L$26=E5)*O2:O26*P2:P26)
5) SUMSQ = SUMSQ(C17,D17)
6) SUMX2MY2 = SUMX2MY2(C17,D17)
7) SUMX2PY2 = SUMX2PY2(C17:C18,D17:D18)
8) SUMXMY2 = SUMXMY2(C17:D17,F17:G17)

Hello Friends,
We have explained Excel tricks and tactics in detail in each video.
Please do visit our channel and given links below.
See Our All Videos:   • Excel Charts Series (English)  
Our Short Video:    • Excel-Short Trick Series (English)  
Visit Our Channel:    / @excelexperthat  

Our Long Videos:
1) Using Slicers in Excel to Filter Data
   • Using Slicers in Excel to Filter Data (V007)  
2) Excel Gantt Chart with Pivot Table
   • Excel Gantt Chart with Pivot Table (V006)  
3) Progress Bar in Excel Cells & Conditional Formatting
   • Progress Bar in Excel Cells & Conditional ...  
4) Excel Workday function: Find end date & exclude weekends & holidays
   • Excel Workday function: Find end date & ex...  
5) Project Plan in Excel with Gantt Chart (Plan, Actual & Progress, Work Priority)
   • Ultimate Excel Gantt Chart Tutorial ( OnTr...  
6) Remove author from the file properties – Excel
   • Remove author from the file properties - E...  
7) Excel Pivot Tables EXPLAINED in 15 Minutes (Productivity, Slicer tips included!)
   • Excel Pivot Tables EXPLAINED in 15 Minutes...  
8) How to Use SUM, SUMIF, SUMSQ, SUMIFS, SUMXMY2, SUMX2PY2, SUMX2MY2, SUMPRODUCT Formula in Excel
   • How to Use SUM, SUMIF, SUMSQ, SUMIFS, SUMX...  

Our Short Video:
1) Your Tab in Excel...Very Simple
   • Your Own Tab in Excel...Very Simple (V018)  
2) How to Show Excel Formulas in Cells with FORMULATEXT Function
   • How to Show Excel Formulas in Cells with F...  
3) Unit Converter in Excel
   • Unit Converter in Excel (V021)  
4) How to find Duplicated in List – Excel
   • How to find Duplicated in List - Excel (V023)