SUMIFS Function in Excel - How to Use SUMIFS function with 5 Examples

Рет қаралды 15,636

Күн бұрын

SUMIFS function in Excel - How to use SUMIFS function with 5 examples and a sample file to download and follow along.
Learn more than 150 Excel functions - amzn.to/3Rg87Go
SUMIFS in Excel is one of the best functions. It is so incredibly useful and easy to learn with this video tutorial.
Learn how to use SUMIFS function in Excel including with dates and with multiple criteria.
Download the sample file
www.computergaga.com/_excel/f...
Here are the timings of the video.
00:00 - Introduction and download the sample file
00:24 - How to use SUMIFS function in Excel
03:11 - Check the answer
04:01 - Sum values based on a cell value
04:50 - SUMIFS function with multiple criteria
06:06 - SUMIFS testing a numeric value
08:29 - SUMIFS function in Excel using dates
Find more great free tutorials at;
www.computergaga.com
** Online Excel Courses **
The Ultimate Excel Course - Learn Everything ► bit.ly/UltimateExcel
Excel VBA for Beginners ► bit.ly/37XSKfZ
Advanced Excel Tricks ► bit.ly/3CGCm3M
Excel Formulas Made Easy ► bit.ly/2ujtOAN
Creating Sports League Tables and Tournaments in Excel ► bit.ly/2Siivkm
Connect with us!
LinkedIn ► / 18737946
Instagram ► / computergaga1
Twitter ► / computergaga1

Пікірлер: 36

@wayneedmondson1065 3 жыл бұрын

Hi Alan. Love SUMIFS! Thanks for sharing this lesson :)) Thumbs up!!

@Computergaga 3 жыл бұрын

Many thanks, Wayne.

@stavrosbatsaktsis8698 2 жыл бұрын

That was one great tutorial! Thank you very much, Computergaga!

@lynxwomancat 3 жыл бұрын

I have been learning this function and you drove home the ease of use. Thanks, Alan!

@Computergaga 3 жыл бұрын

Great to hear! Thanks, Sandy.

@IvanCortinas_ES 3 жыл бұрын

Great tutorial. Thank you Alan!

@Computergaga 3 жыл бұрын

Thank you, Iván.

@mohideenthassim7180 3 жыл бұрын

As usual another great video from you Alan, many thanks

@Computergaga 3 жыл бұрын

Thank you, Mohideen.

@markpodesta4605 3 жыл бұрын

Thank you Alan. Very useful.

@Computergaga 3 жыл бұрын

Very welcome. Thanks, Mark.

@darrylmorgan 3 жыл бұрын

Cool Tutorial,SUMIFS Is Such A Great Function...Thank You Alan :)

@Computergaga 3 жыл бұрын

It really is! 👍 Thank you, Darryl.

@ExcelOffTheGrid 3 жыл бұрын

Good stuff Alan - keep them coming. 😀

@Computergaga 3 жыл бұрын

Thank you, Mark 😊

@richardgordon Жыл бұрын

Brilliant as usual! 👍👍

@Computergaga Жыл бұрын

Thank you Richard.

@gregoryunderwood4121 3 жыл бұрын

Very cool!!! Thank you so much!! I see now what I was doing wrong

@Computergaga 3 жыл бұрын

Thank you, Gregory 👍

@philipmcdonnell7168 3 жыл бұрын

Just what I needed, Alan. Many thanks for sharing.

@Computergaga 3 жыл бұрын

Thank you, Phil. I hope you're doing well, pal.

@philipmcdonnell7168 3 жыл бұрын

@@Computergaga Yes. Keeping out of the way of the plague. Trying to up my coding game but keep getting diverted onto boring stuff. Stay safe. 😷🖖🏻

@Computergaga 3 жыл бұрын

You too, mate.

@meranism673 2 жыл бұрын

Thank you for the information sir. I would like to see if there is a way to apply the same method for several columns? I have a sheet where I input my monthly expenses and I separated it by months. So each month has it's own expenses in different column. Is there a way to get a sum for a specific expense, let say (GAS)? I would really appreciate it if you could help me. Other wise the way I do it now I get a sum for each month and then add up all those numbers to get a sum of all. That's taking a long time to put the same equation for each month over and over again. =SUMIF(A3:A25,"*"&AI5&"*",B3:B25)+SUMIF(C3:C25,"*"&AI5&"*",D3:D25) - this is what I use. but I have to do it for 12 months. Is there a shortcut for achieving the same result?

@cliveburt2638 Жыл бұрын

Instead of having a column for each month, just add 1 column for the month value (which you can then select), an use as an additional selection criteria.