New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 203rd installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SUMIF function to sum with specific criteria.
Learn about the syntax that the SUMIF function uses and see different methods to achieve the same goal.
Follow WonderHowTo on Facebook, Twitter, Pinterest, and Flipboard
How To:
Find a P-Value with Excel
How To:
Create a Basic Attendance Sheet in Excel
How To:
Generate random numbers (with decimals) in Excel
How To:
Enter formulas in Excel with a macro
How To:
Compare two lists and extract the new values in Excel
How To:
Sum dollar amounts from a column in Micrsoft Excel
How To:
Extract part of a table from a larger table in Excel
How To:
Clear data & cell contents in Excel using a macro
How To:
Create a percentage frequency table in Microsoft Excel
How To:
Use AGGREGATE instead of SUBTOTAL in MS Excel 2010
How To:
Insert macro from the Internet into an Excel worksheet
How To:
Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'
How To:
Calculate a bonus in Microsoft Excel
How To:
Conditionally format at every change in value in Excel
How To:
Extract records that meet certain criteria in Excel
How To:
Create a Tangent Line with Excel
How To:
Summarize survey results with a pivot table in Excel
How To:
Find critical values with T functions in MS Excel
How To:
Calculate APR, EAR & period rates in Microsoft Excel 2010
How To:
Calculate Commission Based on Varying Rates in Excel
How To:
Find a P-Value with Excel
How To:
Create a Basic Attendance Sheet in Excel
How To:
Generate random numbers (with decimals) in Excel
How To:
Enter formulas in Excel with a macro
How To:
Compare two lists and extract the new values in Excel
How To:
Sum dollar amounts from a column in Micrsoft Excel
How To:
Extract part of a table from a larger table in Excel
How To:
Clear data & cell contents in Excel using a macro
How To:
Create a percentage frequency table in Microsoft Excel
How To:
Use AGGREGATE instead of SUBTOTAL in MS Excel 2010
How To:
Insert macro from the Internet into an Excel worksheet
How To:
Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'
How To:
Calculate a bonus in Microsoft Excel
How To:
Conditionally format at every change in value in Excel
How To:
Extract records that meet certain criteria in Excel
How To:
Create a Tangent Line with Excel
How To:
Summarize survey results with a pivot table in Excel
How To:
Find critical values with T functions in MS Excel
How To:
Calculate APR, EAR & period rates in Microsoft Excel 2010
How To:
Calculate Commission Based on Varying Rates in Excel
Be the First to Comment
Share Your Thoughts