If you’re looking at this function then you must be familiar with the SUM function or using AutoSum to add up a selection of cells. SUMIF is neat as it totals up only those cells that meet certain criteria such as totalling up values for purchases in a given month or if you want to see the total sales by someone and not the entire sales team. This video tutorial shows you how to use the SUMIF function.
Latest Tutorial: PowerPoint Creating a Video from Presentation
Check out my latest tutorial on my website. How to create a video from a PowerPoint Presentation-
Recent Posts
Archives
- May 2018
- February 2018
- July 2017
- June 2017
- February 2017
- November 2016
- October 2016
- August 2016
- July 2016
- June 2016
- April 2016
- February 2016
- January 2016
- December 2015
- November 2015
- October 2015
- September 2015
- August 2015
- July 2015
- June 2015
- May 2015
- April 2015
- February 2015
- January 2015
- December 2014
- November 2014
- October 2014
- September 2014
- August 2014
- June 2014
- May 2014
- April 2014
- March 2014
- February 2014
- January 2014
- December 2013
- November 2013
- October 2013
- September 2013
- August 2013
- July 2013
- June 2013
- May 2013
- April 2013
- March 2013
- February 2013
- January 2013
- December 2012
- November 2012
- October 2012
- September 2012
- August 2012
- July 2012
- June 2012
- May 2012
- October 2011
- September 2011
- July 2011
- March 2011
- February 2011
- January 2011
- December 2010
- October 2010
- September 2010
- July 2010
- June 2010
Categories
- Action photos
- adobe creative cloud
- Adobe Premiere Elements
- Adobe Premiere Pro
- Android
- Apple
- apps
- camera
- Charts
- cloud
- Computing
- Dieting
- digital photography
- Dropbox
- dslr
- eBay
- evernote
- Excel
- Excel Functions
- file management
- Final Cut Pro
- gmail
- Handoff
- iCloud
- iCloud Photo Library
- imac
- iMovie
- Instant Hotspot
- Internet
- iOS
- ios 10
- iOS 7
- iOS 8
- iOS 9
- iOS6
- iOS7
- iPad
- iPad Pro
- Iphone
- iPhone 5S
- iPhone 6
- iPhone 6 Plus
- iTunes
- Learn DSLR
- Lightroom
- mac os x
- macbook
- Management
- Mavericks
- Microsoft Access
- Microsoft Office
- microsoft word
- mobile computing
- mobile devices
- Office 2010
- Pages
- photography
- Photoshop
- Podcasting
- PowerPoint
- Presentation
- productivity
- Samsung Galaxy S4
- Screencast
- security
- Shopping Online
- Smartphone
- social media
- Sports photography
- Tablet
- Technology
- travel
- TV
- Uncategorized
- utility
- VBA
- video
- Video editing
- Visual Basic for Applications
- Weight loss
- wifi
- windows 7
- Windows 8.1
- word
- word 2010
- Yosemite
- YouTube
Meta
Latest Tutorials
- About
- AutoFill to Copy Data, Values,Functions and Formulas and Also to Create a Series
- AutoSum to Total Up a Column, Row or Range
- Calculating the Number of Days Between Dates
- Conditional Formatting
- Contact
- Creating a Pie Chart in Excel 2003
- Excel Tutorials
- Formatting Data Series in a Chart
- Freeing Up Memory on Your Mac OS X
- Getting Start with Charts in Excel 2010
- Getting Started with Excel 2010
- Goal Seek
- IF Function
- Introduction to Date Functions
- Introduction to Excel Functions
- Introduction to Functions on a Mac
- Naming Cells and Ranges
- PowerPoint Tutorials
- PowerPoint: Using Slide Master
- Printing a Selected Area
- Recording a Macro in Excel 2003
- Resizing Columns and Rows
- Splitting the First Name and Last Name in a Cell into Two Separate Cells
- SUMIF Function
- The COUNTIF Function
- The Payment (PMT) Function for Calculating Repayments on Loans
- Using a Percentage in a Formula
- Using Data Validation to Create a Drop Down List
- Using Scenarios (also known as the Scenario Manager)
- Using the $ signs in an Excel Formula or Function for Absolute and Mixed Referencing
- Using the TODAY() Function to Calculate Someone’s Age
- VLOOKUP Function
Follow me on Twitter
My Tweets