SUMIFS Function in Excel - How to Use SUMIFS function with 5 Examples
ฝัง
- เผยแพร่เมื่อ 8 ก.ค. 2024
- 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 - แนวปฏิบัติและการใช้ชีวิต
Hi Alan. Love SUMIFS! Thanks for sharing this lesson :)) Thumbs up!!
Many thanks, Wayne.
That was one great tutorial! Thank you very much, Computergaga!
I have been learning this function and you drove home the ease of use. Thanks, Alan!
Great to hear! Thanks, Sandy.
Great tutorial. Thank you Alan!
Thank you, Iván.
Thank you Alan. Very useful.
Very welcome. Thanks, Mark.
As usual another great video from you Alan, many thanks
Thank you, Mohideen.
Good stuff Alan - keep them coming. 😀
Thank you, Mark 😊
Cool Tutorial,SUMIFS Is Such A Great Function...Thank You Alan :)
It really is! 👍 Thank you, Darryl.
Brilliant as usual! 👍👍
Thank you Richard.
Just what I needed, Alan. Many thanks for sharing.
Thank you, Phil. I hope you're doing well, pal.
@@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. 😷🖖🏻
You too, mate.
Very cool!!! Thank you so much!! I see now what I was doing wrong
Thank you, Gregory 👍
good job
Thank you, Ubaidillah 😊
☺
😀
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?
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.
How to download this file from the video link
When you click the link in the description it will download immediately. Check the 'Downloads' folder, Emtiazul.
How can I create a formula as follows?
If I have a value 5,500,000
To take up only 1,000,000
If the Value is less than 1,000,000 remain as itself
If(A1>=1000000,1000000,A1) this means if the value of A1 is equal or greater than 1000000, then cell value is 1000000, otherwise cell value = A1.
@@cliveburt2638 thx, all da best
@@cliveburt2638
But, If I have cell A1 is less than 1,000,000, How Can I fix the value less than 1,000,000.
Look for help, thx in advance
I think you're after the opposite of the provided formula If(A1