This video explains how to use SumIF in Microsoft Excel. SumIF
This tutorial explains how to use SUMIF in Microsoft Excel. SUMIF How to use the SUMIF function with tables and charts. The tutor explains how to create a basic SUMIF function using cell references and locked columns. Following on, the tutor demonstrates how to use named ranges in the SUMIF function to avoid using dollars sign to lock columns. The tutor also covers how to use SUMIF instead of a HLOOKUP function. Finally, the tutor explains how to use the SUMIF function with DATE functions to create a Dynamic chart. This video is a Microsoft Excel tutorial covering SUMIF, DATE Functions and Named Ranges.
#msexcel
Most popular video at the moment: Spill Error, https://www.youtube.com/watch?v=uyNXVbpfsiE
If you want to support me, check this out: https://www.patreon.com/itseasy
Playlists for this channel:
Access: https://www.youtube.com/watch?v=WyFj2eeMfSI&list=PLK99llucAWls71sYcwuXUGuTB33Iz4sFP&ab_channel=ITsEasyTraining1st
Excel: https://www.youtube.com/watch?v=yKobsDbGbyM&list=PLK99llucAWlt5BjHVQwlzFWcqtOR0xMsc&ab_channel=ITsEasyTraining1st
Word: https://www.youtube.com/watch?v=1yB2yP_5LQ0&list=PLK99llucAWlvAvYnQHbuqPzahwXC2GP5T&ab_channel=ITsEasyTraining1st
Visio: https://www.youtube.com/watch?v=ucHD0C4xeBY&list=PLK99llucAWlubxRVLca37R6Jh4jSZyxC3&ab_channel=ITsEasyTraining1st
Project: https://www.youtube.com/watch?v=5Fmgei_PagI&list=PLK99llucAWltWM3-Ohg_V1d6Q0STPAzG7&ab_channel=ITsEasyTraining1st
PowerPoint: https://www.youtube.com/watch?v=fOhiNLAzVAQ&list=PLK99llucAWluWCI4_xLnfbjm5GpAZo9Ye&ab_channel=ITsEasyTraining1st
Publisher: https://www.youtube.com/watch?v=I1-DPJTSvg4&list=PLK99llucAWlvCyOwrQh-OSlPpXWBIEVYq&ab_channel=ITsEasyTraining1st
OneNote: https://www.youtube.com/watch?v=JS5Y_BSEbgg&list=PLK99llucAWlteO7uOpQHz5rOBCdnZ0YMD&ab_channel=ITsEasyTraining1st
Office 365: https://www.youtube.com/watch?v=fphQ0jmv0-8&list=PLK99llucAWlv0L0K0wsLW_S5VkOHFuxli&ab_channel=ITsEasyTraining1st
#itseasytraining
Classroom based courses can be arranged at https://www.itseasy.co.uk/
Courses are available through Microsoft Teams, Online and Face to face in the UK
Online courses at https://itseasytraining.teachable.com/
Udemy Courses https://www.udemy.com/user/stephen-saxton/
Training Guide Books
Excel for New Managers
https://www.amazon.co.uk/Excel-New-Managers-understanding-Microsoft/dp/1695396863
Microsoft Project Overview https://www.amazon.co.uk/Microsoft-Project-Overview-need-about/dp/1705474632
Microsoft Visio Basic https://www.amazon.co.uk/Microsoft-Visio-Basics-Stephen-Saxton/dp/B089CSJBMD
Very cheap E_books are here:
Excel For New Managers https://payhip.com/b/IE4x
Microsoft Project Overview https://payhip.com/b/wY0m
Microsoft Visio Basics https://payhip.com/b/5XeV
Microsoft Access Introduction https://payhip.com/b/ynSL
A PowerPoint Overview https://payhip.com/b/YkQv
Видео This video explains how to use SumIF in Microsoft Excel. SumIF канала ITsEasyTraining1st
#msexcel
Most popular video at the moment: Spill Error, https://www.youtube.com/watch?v=uyNXVbpfsiE
If you want to support me, check this out: https://www.patreon.com/itseasy
Playlists for this channel:
Access: https://www.youtube.com/watch?v=WyFj2eeMfSI&list=PLK99llucAWls71sYcwuXUGuTB33Iz4sFP&ab_channel=ITsEasyTraining1st
Excel: https://www.youtube.com/watch?v=yKobsDbGbyM&list=PLK99llucAWlt5BjHVQwlzFWcqtOR0xMsc&ab_channel=ITsEasyTraining1st
Word: https://www.youtube.com/watch?v=1yB2yP_5LQ0&list=PLK99llucAWlvAvYnQHbuqPzahwXC2GP5T&ab_channel=ITsEasyTraining1st
Visio: https://www.youtube.com/watch?v=ucHD0C4xeBY&list=PLK99llucAWlubxRVLca37R6Jh4jSZyxC3&ab_channel=ITsEasyTraining1st
Project: https://www.youtube.com/watch?v=5Fmgei_PagI&list=PLK99llucAWltWM3-Ohg_V1d6Q0STPAzG7&ab_channel=ITsEasyTraining1st
PowerPoint: https://www.youtube.com/watch?v=fOhiNLAzVAQ&list=PLK99llucAWluWCI4_xLnfbjm5GpAZo9Ye&ab_channel=ITsEasyTraining1st
Publisher: https://www.youtube.com/watch?v=I1-DPJTSvg4&list=PLK99llucAWlvCyOwrQh-OSlPpXWBIEVYq&ab_channel=ITsEasyTraining1st
OneNote: https://www.youtube.com/watch?v=JS5Y_BSEbgg&list=PLK99llucAWlteO7uOpQHz5rOBCdnZ0YMD&ab_channel=ITsEasyTraining1st
Office 365: https://www.youtube.com/watch?v=fphQ0jmv0-8&list=PLK99llucAWlv0L0K0wsLW_S5VkOHFuxli&ab_channel=ITsEasyTraining1st
#itseasytraining
Classroom based courses can be arranged at https://www.itseasy.co.uk/
Courses are available through Microsoft Teams, Online and Face to face in the UK
Online courses at https://itseasytraining.teachable.com/
Udemy Courses https://www.udemy.com/user/stephen-saxton/
Training Guide Books
Excel for New Managers
https://www.amazon.co.uk/Excel-New-Managers-understanding-Microsoft/dp/1695396863
Microsoft Project Overview https://www.amazon.co.uk/Microsoft-Project-Overview-need-about/dp/1705474632
Microsoft Visio Basic https://www.amazon.co.uk/Microsoft-Visio-Basics-Stephen-Saxton/dp/B089CSJBMD
Very cheap E_books are here:
Excel For New Managers https://payhip.com/b/IE4x
Microsoft Project Overview https://payhip.com/b/wY0m
Microsoft Visio Basics https://payhip.com/b/5XeV
Microsoft Access Introduction https://payhip.com/b/ynSL
A PowerPoint Overview https://payhip.com/b/YkQv
Видео This video explains how to use SumIF in Microsoft Excel. SumIF канала ITsEasyTraining1st
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![This video explains how to use the XLOOKUP function in Google Sheets](https://i.ytimg.com/vi/LTfBTTvfesw/default.jpg)
![Secrets to Animated Diagrams in PowerPoint](https://i.ytimg.com/vi/jx_eD9d4Vs4/default.jpg)
![Organisational Charts in Microsoft Visio](https://i.ytimg.com/vi/3W45oPYCGlc/default.jpg)
![Use Visio online and bring extra shapes into the desktop version](https://i.ytimg.com/vi/Vzh6lp5NFg8/default.jpg)
![Auto Text verses Auto Correct in Microsoft Word](https://i.ytimg.com/vi/95Q35TPl3BQ/default.jpg)
![Mastering Forms in Microsoft Project: Expert Tips](https://i.ytimg.com/vi/pwCJE5FDAPg/default.jpg)
![How to check resource availability in Microsoft Project](https://i.ytimg.com/vi/v1_9qYJ8vJ4/default.jpg)
![Excel visualisations. Use 3D maps to visualise data](https://i.ytimg.com/vi/BawXylq6--M/default.jpg)
![Secrets to Perfect Process Diagrams with Visio](https://i.ytimg.com/vi/OgPMYMzgkN8/default.jpg)
![Stop: Anyone From Deleting Your Protected Sheets](https://i.ytimg.com/vi/ilbpjZ9OtOM/default.jpg)
![How to create a Website map using Microsoft Visio](https://i.ytimg.com/vi/aF50cC7eElc/default.jpg)
![Fill in Forms that auto update in Microsoft Word. Auto Update](https://i.ytimg.com/vi/AYUA23Ss3_E/default.jpg)
![Showcase your best self: tips for a successful presentation](https://i.ytimg.com/vi/FVUmLSc9e5c/default.jpg)
![How to create dependant l drop down lists in Microsoft Excel](https://i.ytimg.com/vi/sVgiqczWqVQ/default.jpg)
![The new TAKE function in Microsoft Excel.](https://i.ytimg.com/vi/ezcnpg7WOQs/default.jpg)
![How to attract an audience in a Microsoft PowerPoint presentation](https://i.ytimg.com/vi/ywwVxyaKdd4/default.jpg)
![Microsoft Project the best bits. Getting started with Project](https://i.ytimg.com/vi/-rKPeeM-6qE/default.jpg)
![How to link charts and automatically update in Microsoft Word](https://i.ytimg.com/vi/-5QZ9JtReAk/default.jpg)
![Discover the secret to chart creation speed](https://i.ytimg.com/vi/rAonMPP7eIY/default.jpg)
![Excel Tips: Highlight and Count Occurrences to Spot Trends and Save Time](https://i.ytimg.com/vi/KqJudeWnOqc/default.jpg)
![How to create a table of contents in Google Docs](https://i.ytimg.com/vi/Rx5Sf2XSMX4/default.jpg)