Excel Magic Trick 694: SUMIF Can't Handle Arrays. SUMIF(YEAR(A2:A10),2010,B2:B10) Won't Work
Loading...
Loading...
6:03
Excel Magic Trick 695: Allocate Total Costs across Categories Including Extra Penniesby ExcelIsFun992 views- 3:51
Excel Magic Trick 693: HOW Long To Double Your Money: NPER function or Rule of 72.by ExcelIsFun1,179 views
- 7:38
Excel Magic Trick 696: Identify First Occurrence In Column (5 methods)by ExcelIsFun1,062 views
- 10:34
Excel Magic Trick 697: Extract Month Year Records From Transactional Data - 3 Methodsby ExcelIsFun1,701 views
- 7:03
Use COUNTIF and SUMIF to Identify and Total Past Due Invoice Amounts in Excelby DannyRocksExcels8,376 views
- 1:30
Excel Magic Trick 475: SUMPRODUCT for Bank Deposit Calculationby ExcelIsFun1,851 views
- 4:57
Excel 2007-2010 SUMIF and SUMIFS Formulas.movby ejmagidson929 views
- 4:52
Excel Magic Trick 721: Convert Text Time Numbers Without A Colon To Time 0655 into 06:55 AMby ExcelIsFun3,680 views
- 4:03
Excel Magic Trick 553: SUMIF for Dollars and Eurosby ExcelIsFun2,215 views
- 14:31
Excel Magic Trick 741: Avoid Errors & Blanks In Chart Using Formulas & Defined Name Dynamic Rangesby ExcelIsFun2,683 views
- 12:22
Excel Magic Trick 718: Calculate Hours Worked (Day or Night Shift) & Subtract Lunchby ExcelIsFun14,616 views
- 3:38
Excel Magic Trick 734: Downloaded Decimal (Percentage) Grades into Actual Integer Gradesby ExcelIsFun1,859 views
- 2:12
Excel Magic Trick 716: Max of Absolute Values MAX & ABS functions Array Formulaby ExcelIsFun2,532 views
- 2:44
Excel Magic Trick 749: Add Yearly Totals From Daily Date Data without SUMIF Functionby ExcelIsFun980 views
- 2:12
Microsoft excel gamesby Tigger44814,356 views
- 18:02
Excel Magic Trick 744: Break Even Analysis Formulas Chart & Plotting Break Even Point On Chartby ExcelIsFun20,873 views
- 4:12
Excel Magic Trick 725: Which Quartile Are You In? INPUT your Score, Formula Says Quartile You Are Inby ExcelIsFun1,799 views
- 4:16
MS EXCEL 2010 Using SUM IF and AVERAGE IFby MyWorkHome1,519 views
- 1:57
How to remove an excel password without knowing itby dualbreathe82,451 views
- 18:17
Excel Magic Trick 629: HR Salary Calculation Based On Relevant Years Worked (2 methods)by ExcelIsFun7,777 views
If you wnat to add the B column, use:
=SUMPRODUCT(--(YEAR(A2:A10)=D3),B2:B10)
ExcelIsFun 1 year ago
this look more to counting but how to sum the qty to get total number?
yuenmxk 1 year ago
That is for sure!
ExcelIsFun 1 year ago
Perhaps some better error responses would help as well. :)
krn14242 1 year ago