SEARCH

Start Here
Learn
Excel Podcast
Listen to John Michaloudis interview various Excel experts & MVPs to get their inisghts & tips
Functions & Formulas
Learn how to use the Lookup, Text, Logical, Math, Date & Time, Array plus more functions & formulas
Pivot Tables
Learn Slicers, Pivot Charts, Calculated Fields/Items, Grouping, Filtering, Sorting, plus more
Macros & VBA
Learn how to automate your worksheet & reports with ready made VBA code
Power BI, Power Query & Power Pivot
Discover the new Business Inteligence & data visualization tools from Microsoft
Charts
Learn to create Smart Art, Column, Line, Pie, Bar, Area, Scatter, Bubble and Sparkline charts
Analysis
Learn Conditional Formatting, Data Validation, Excel Tables, Find & Select, Sort, Filter plus more
Shortcuts & Tips
Explore the various keyboard shortcuts & tips to make you more efficient in Excel
Webinars
Pivot Tables Webinar
Analyze tons of data with a couple of mouse clicks and create Excel Dashboards
Learn More
Functions & Formulas Webinar
Learn the must know Functions & Formulas: IF, SUMIF, VLOOKUP, INDEX/MATCH plus more
Learn More
Macros & VBA Webinar
Learn how to record Macros, write VBA code and automate your worksheet & reports
Learn More
Academy

Featured course:
MyExcelOnline Academy Online Course
Access a library of 500+ Excel video tutorials covering all levels and features like: Formulas, Macros, VBA, Pivot Tables, Power BI, Power Query, Power Pivot, Dashboards, Financial Modelling, Charts, Access, Word, PowerPoint, Outlook plus MORE!

Learn More
Corporate Academy Online Course
Get your team skilled up in Excel and save with our corporate packages
See why leading organizations choose MyExcelOnline as their destination for employee learning
Academy Members Login
If you are a current Academy member, click here to login & access this course
Resources

Featured resource:
Excel Consulting Services
Get FAST, EXPERT help on any Excel problem or template with our Excel Consulting Services!
Choose from the different Microsoft Excel and Office features that we can help you with today…

Get a FREE Quote
101 Most Popular Excel Formulas E-Book
Learn the most popular Excel Formulas ever: VLOOKUP, IF, SUMIF, INDEX/MATCH, COUNT, SUMPRODUCT plus more
101 Ready To Use Excel Macros E-Book
Access 101 Ready To Use Macros with VBA code which you can Copy & Paste to your workbooks straight away
101 Most Popular Excel Formulas Paperback on Amazon
Learn the most popular Excel Formulas ever: VLOOKUP, IF, SUMIF, INDEX/MATCH, COUNT, SUMPRODUCT plus more
101 Ready To Use Excel Macros Paperback on Amazon
Access 101 Ready To Use Macros with VBA code which you can Copy & Paste to your workbooks straight away
Search

DOWNLOAD OUR FREE EXCEL RESOURCE GUIDE E-BOOK! FREE FORMULAS, VBA &
PIVOT TABLE COURSES. JOIN NOW!

LATEST POSTS
FORMULAS
Lookup
VLOOKUP INDEX INDEX/MATCH INDIRECT MATCH OFFSET SUM
Text
BETWEEN CLEAN CONCATENATE LEFT LEFT & FIND LEN PROPER REPLACE RIGHT SUBSTITUTE TRIM TRIM & SUBSTITUTE
Logical
IF IFERROR
Math
SUMPRODUCT AVERAGE MOD RAND ROUND SUBTOTAL SUMIF SUMIFS RANDBETWEEN OTHER MATH
Date & Time
DATEDIF EOM WEEKDAY WORKDAY
Other
ARRAY 3D Formulas Financial TIP
PIVOT TABLES
Customize Analysis Group Sort Calculated Fields & Items Filter Slicers Pivot Charts Conditional Formatting Other
MACROS
CHARTS
Smart Art Column Line Pie Bar Area Scatter Bubble Sparklines Formatting Charts Excel 2016 Charts Infographic
POWER BI
Power Query Power Pivot
ANALYSIS
Conditional Formatting Data Validation Excel Tables Find & Select Sort & Filter Other
SHORTCUTS
Keyboard Tips and Tricks
ADD-INS
SEARCH

Sumifs

SUMIFS function: Wildcards *

October 4, 2014

Continue reading

SUMIFS Function: Introduction

October 4, 2014

Continue reading

ABOUT ME

Hello, My name is John Michaloudis from MyExcelOnline. Click here to read my story!

Helpful Excel Resources

333 Excel Shortcuts for Windows and Mac
101 Excel Formulas & Functions Examples
50 Things You Can Do With Excel Pivot Tables
50 Things You Can Do With Excel Power Query
Free Excel Webinar Online Training Courses
026: The Best Microsoft Excel Tips & Tricks in 2019!

Microsoft Excel Online Course Training

Most Popular Posts

Create a Data Entry Form in Excel
Connect Slicers to Multiple Excel Pivot Tables
VLOOKUP Example: Vlookup with a Drop Down List
Advanced SUMPRODUCT Function: Sum Multiple Criteria
Named Ranges with Vlookup Formula
Sum a Range Using the INDEX Function
VLOOKUP with Multiple Criteria in Excel
Concatenate With A Line Break
Bubble Chart: 3 Variables On A Chart
100% Stacked Column Chart: Percentage Contributions
INDIRECT Function Using Sheet References

COME HANG OUT WITH ME

© Copyright 2020 MyExcelOnline SLU. All rights reserved.

Contact
Privacy Policy
Cookie Policy
Sitemap

LEARN

Excel Podcast
Functions & Formulas
Pivot Tables
Macros & VBA
Power BI
Charts
Analysis
Shortcuts & Tips

WEBINARS

Pivot Table
Functions & Formulas
Macros & VBA

ACADEMY

MyExcelOnline Academy Online Course
Corporate Academy Online Course
Academy Members Login

RESOURCES

Excel Consulting Services
Formulas E-Book
Macros E-Book
Formulas Paperback on Amazon
Macros Paperback on Amazon
Accountant jobs

FOLLOW ME

SEARCH EXCEL TUTORIALS

Popular searches »

50 Things You Can Do With Excel Pivot Tables
101 Excel Formulas & Functions Examples
50 Things You Can Do With Excel Power Query
Free Excel Webinar Online Training Courses
026: The Best Microsoft Excel Tips & Tricks in 2019!
New Excel Formulas in OFFICE 365: FILTER, RANDARRAY, SEQUENCE, SORT, SORTBY and UNIQUE!

This website uses cookies to ensure you get the best experience on our website. Cookie Policy Got It!

Privacy & Cookies Policy

Necessary

Necessary

Always Enabled

This is an necessary category.

Uncategorized

uncategorized

Functional

functional

Analytics

analytics

Advertisement

advertisement

Performance

performance

Save & Accept