Excel SUMIFS Sum With Multiple Criteria
Loading...
Loading...
1,005
Loading...
Uploaded by contextures on Jan 27, 2012
http://www.contextures.com/xlfunctions01.html In Excel 2007 and Excel 2010, you can use the new SUMIFS function to sum items using multiple criteria.
For example, sum the orders where an account is Active, and the quantity is greater than or equal to 10.
This video shows the steps for using the SUMIFS function, and using cell references instead of hard coded values.
- 4 likes, 0 dislikes
-
Uploader Comments (contextures)
see all
All Comments (3)
-
Thanks for showing this function off!
Loading...
- 36:28
Excel Magic Trick 777: SUMPRODUCT Function -- Basics To Advanced (14 Examples)by ExcelIsFun6,250 views
- 16:06
Excel Magic Trick 834: Average with Multiple Criteria Data Spread Out Across Many Sheets & Columnsby ExcelIsFun1,157 views
- 10:16
The SUMIFS and DSUM Functions use Multiple Criteria in Excelby DannyRocksExcels907 views
- 9:22
Use the SumIf and SumIfs Functions in Excel to Analyze Accounts Receivable Status Reportby DannyRocksExcels3,119 views
- 10:22
Excel Magic Trick 315: SUMIF Only Accept Ranges, Not Arraysby ExcelIsFun5,500 views
- 12:04
Excel Magic Trick 851: Formula To Sum Unique Values In Columnby ExcelIsFun2,091 views
- 8:58
Excel Magic Trick 779: SUMIFS Faster Than SUMPRODUCT & TEXT When Using "Jan" Month Criteriaby ExcelIsFun3,938 views
- 1:09:39
Excel Magic Trick 778: INDEX & MATCH Functions Beginning To Advanced (18 Examples)by ExcelIsFun21,429 views
- 9:34
Excel VBA tutorial 9 IF Statment less than and greater than and AND operatorby Malfunction93,379 views
- 20:20
Excel Magic Trick 793: Add Between Two Dates/Times/Numbers SUMIF & SUMIFS 10 Examplesby ExcelIsFun4,945 views
- 13:26
Excel Magic Trick 642: SUMIFS function or PivotTable For Household Budget Summary Tableby ExcelIsFun5,157 views
- 7:48
How to Use SUMPRODUCT To Total an Excel List Using Multiple Criteriaby DannyRocksExcels2,871 views
- 7:38
Excel Magic Trick #33 Add Multiple Criteria SUMIFS function.flvby b2btailoc315 views
- 8:17
YouTubers Love Excel 12: Pivot Table AVERAGEIF SUMIF/COUNTIFby ExcelIsFun16,224 views
- 8:57
Excel Magic Trick 840: Frequency & Total for Upper and Lower Limit Category Formulas or PivotTable?by ExcelIsFun581 views
- 12:20
Office 2010 Class #38: Excel IF Function Formula Made Easy (7 examples)by ExcelIsFun26,466 views
- 8:21
Excel Magic Trick 572: COUNTIF & SUMIFS functions & Logical Formulas have Different Syntaxby ExcelIsFun5,186 views
- 9:19
Highline Excel Class 09: SUMIF Function Formula 3 Examplesby ExcelIsFun28,761 views
- 6:25
Show Specific Info in Excel UserFormby contextures746 views
- 9:56
How to Use VLOOKUP in Microsoft Excel 2010by QuePublishing61,823 views
Thanks Debra
krn14242 1 month ago
@krn14242 You're welcome, and thanks for your comment. Hope you can find a use for SUMIFS
contextures 1 month ago