How to do SUMIF with Multiple Columns Tutorial - SUMIFS in Excel

[@annbell9177]

Madam thank you so much, of all excel tutorials I have watched, you are really doing an amazing job, I love your tutorials.

[@SimonSezIT]

You are very welcome! Thanks for watching 🙂 🔥Check out our FREE 300+ hour training course playlist here 👉 kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU 🚀 Level up your Excel skills with free training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI & Pivot Table training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gu_cJg5cV8RDdBNUVOvG5u For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZbin Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzbin.info ♥️ We appreciate your support!

[@SimonSezIT]

We have additional free Excel training here 👉kzbin.info/aero/PLzj7TwUeMQ3jqRlmIaj6jb_X9EGQueMDb & here👉kzbin.info/www/bejne/hp2zmIyFe6-Fhas & PivotTable training here 👉 kzbin.info/aero/PLzj7TwUeMQ3iJ5hWG_iZuIvFvnuJJ-mtc Check out our FREE 300+ hour training course playlist here ➡ 🔥kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

[@NaeemSiddiqui-q6f]

Great. An excellent video. Perfect explanation of a complicated series of criteria in a very easy and smooth way. EXCELLENT

[@SimonSezIT]

Glad it was helpful! 🔥For more FREE training - check out our 300+ hour playlist here 👉 kzbin.info/aero/PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU

[@dorinaespano77]

Solved my problem! Been looking for this for a day! Thank you thank you so much!

[@SimonSezIT]

Glad it was helpful! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️ kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

[@barbjoblin765]

You are amazing! I struggled all day with my assignment and then came across your tutorial. You explained it so well. Thank you, thank you.

[@SimonSezIT]

Keep up the awesome work and keep learning! 🤩 Learn more Microsoft Excel Tips and Tricks here ➡️ kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc

[@RichardSwitters]

Brilliant lesson - thanks!

[@SimonSezIT]

Glad you enjoyed it. Thanks for watching! 😃

[@zidanealarb2011]

Thank you, it was easy explanation

[@SimonSezIT]

You are very welcome! Glad it was helpful. 🙂 🚀 Level up your Excel skills with free training here 👉 kzbin.info/aero/PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc & here 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI

[@thuswaldner1]

Very good explanation. I am using this in Googlesheets and this explanation works 100%.

[@SimonSezIT]

Awesome! 🙂

[@Ahmedmohamed-f5g4h]

Amazing,Thanks😇

[@SimonSezIT]

Wow, thanks! Glad it was helpful. 🤩

[@hamidnadeem3937]

You did a great Job. Thanks for helping

[@SimonSezIT]

Glad you enjoyed it! Thanks for watching 😃

[@ne8817]

Thank you so much!!!

[@bimpenwoko8229]

Thank you! This is so helpful

[@janridutoit2606]

Is it posible i have in 1 colum values, but i only want it to add greater than 1, but less than 60 ?

[@vikaschander1232]

Is that possible shirt and blouse sale can be sum in one column

[@naufalrifqiarrafi139]

Can I use a same column for a different criteria?

[@meranism673]

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?

[@golammahabub671]

How can I "sumifs" Shirt & Blouse together?

[@SimonSezIT]

If "Shirt" and "Blouse" are in the same column, try using this formula: =SUMIF(A:A,"Shirt",B:B)+SUMIF(A:A,"Blouse",B:B) where the criteria is in column A and the sum range is in column B.

[@usmaniqbal1836]

Plz, also share Excel file...

[@StopDrinkingtheLeftsKoolaid]

Maybe I missed it but it should be known that (that I know of) the sum range is limited to only one column. For instance, there are two columns in two categories but you want to sum the total amount for both categories based on different but relative criteria. I could not get the formula to work until I tried using only one category. If I missed this I apologize.

[@chasitywilliams3534]

thank you so much, this was extremely helpful

[@SimonSezIT]

Thank you for your kind words! We're thrilled that the video was able to help you. 🙂 We have intermediate and advanced Excel 2021/365 training too, if you need it 👉 kzbin.info/aero/PLzj7TwUeMQ3g6U7Mwyy7G9Gwh-k2yNtfI For more information about Simon Sez IT courses, visit: SimonSezIT.com: www.SimonSezIT.com/ Stay in touch! KZbin Channel: www.youtube.com/@SimonSezIT LinkedIn: www.linkedin.com/company/simon-sez-it/ Please SUBSCRIBE ► kzbin.info ♥️ We appreciate your support!