Excel VBA Basics #22 SumIfs Using VBA

[@ExcelVbaIsFun]

you're very welcome. Thank YOU for watching! Dan

[@caribeiro77]

It's not easy to find that kindness you have in our days,,,,,,offering knowledge....we have to pay for everything in our days... hope one day i'll have almost the same knowledge you have to help people(in my language) the same way that you do... bless you

[@ExcelVbaIsFun]

Glad this helps, Luís. Thanks for your comments! Dan

[@lluisc1]

In this globalized world everything has its price and everyone wants to make money, it's rare to find people who share their expertise on behalf of the community ... this side of the Atlantic in Lisbon goes a big thank you for sharing

[@ExcelVbaIsFun]

Absolutely, most people don't know how simple it is to harness its power! Lets teach them! Dan

[@ExcelVbaIsFun]

Claudio, awesome. So glad to be of assistance. Yes, please pay it forward in your language someday, great plan! Dan

[@zmyal]

thanks for this video. If we don't want to name so many tables, we can use the following to reference the certain columns in the "master" table: [pt_Table].Columns(x) 'x is the number of the column in the table

[@ExcelVbaIsFun]

Merry Christmas everyone. I hope God blesses you richly this upcoming year. Remember, you ARE a success!! Believe it, be it! Blessings my friends!! Dan

[@josephkreifelsii6596]

+ExcelVbaIsFun That time of year again!!!!!!!!!!!!!

[@ExcelVbaIsFun]

wow! hey thanks Brian. Got several more to upload today and tomorrow. My pc renders these bad boys pretty slowly! thx Dan

[@palomarodriguez3308]

I've found your videos, including the ones from Udemy, so incredible helpful. THANK YOU! Your kindness really, REALLY shows through, by the way.

[@ExcelVbaIsFun]

Thank you for watching! Happy Resurrection Sunday (Easter)!!

[@josephsgambelluri7865]

Thank you for this video. It was the most well-explained use of SUMIFS for VBA. Other posts/forums I've read try to avoid using SUMIFS and create extra code to do the same thing.

[@Bzini00]

These videos are great!!! Thanks man. Seriously. I hope your getting the feedback you deserve. Welp, on to the next!

[@davidbuaron]

Thanks again Dan! I have a small question -I need to make SUMIFS formula in one workbook and the Data and the crtiria are in another workbook.how can I do tha?

[@ExcelVbaIsFun]

Thank You and you're very welcome! Dan

[@sridharkrishnappanavanerth3388]

excellent tutorial sir, just the tutorial i was looking for.

[@nunitoism]

Hey, thanks again for all the videos. Regarding the ignored debugging that you had in the beginning of the vid. Well, I followed the last lesson and had it as well. And don't know what is wrong. I see that you have it too, but did you address that in any video? Cheers. N.

[@freemen900]

Thank you for sharing your tutorial on Excel. Super useful!!

[@AbdullaKhizamworld]

The same one if we wanted to loop how shall i do. since database is large match each row.

[@archanaaa2514]

Hello sir, y did u use this [ ] kind of brackets in coding? What is d use of dis?

[@nettlesome7125]

An important lesson! Unfortunately, refers to unspecified other videos while 'blazing through' some parts of technique. Workbook is erroneously labeled "ExcelVBAIsFun 10" in dropbox, and module is not clearly identified (look for Module 7). Workbook also includes a button not mentioned during the lesson. These organizational details can be distracting, and generally aren't found in the vast ExcelIsFun collection. All the same, a great resource, and well worth the time.

[@krishnaklv3459]

Hello Sir - I want to Learn VBA i don't now basic also ... there is any Basic videos

[@luisangelrodriguezrodrigue623]

Hola señor... Existe una condición como esta "=A" que usualmente se usa en un SumIFs para encontrar valores relacionados a "A".... Como puedo utilizar esta condición en vba Excel.

[@davidbuaron]

Thank you for doing those videos. great job

[@nazefali3699]

Hi dear Dan or ExcelVbaIsFun, you are amazing person. Teaching is a gift and you have it! God bless you and your family. please is it possible you could create a userform, and get information about patients details, and then all the information transfer on to a worksheet? a small project like patient admmision, we need it for an hospital in my country please, poor one! thank you so much. there is still good people in this life, just like yourself!!

[@krn14242]

So true, Excel is wonderful.. Thanks so much Dan.

[@caballero4321]

Sir. What if instead of the value I would like to get the actual formula in that specific cell...Please tell me how to get the formula instead of the value in the cell...Thank you very much.

[@annalu2294]

Hi Daniel, thank you for all the videos. I have a problem when running the Sumifs function. With the Start Date and End Date, if I format the cells as General, the code works without any problem. But when I format the cells as Short Date and run the code, the Total Sales return 0. I did some research online but couldn't find an answer. Would you please help me with this? I'm looking forward to hearing from you.

[@ExcelVbaIsFun]

Anna Lu Hi Anna Lu, can you show us the exact code or dates/ etc? Blessings! Dan

[@2001jesper]

Great with a VBA series. Thank you

[@gabrielmolefe8599]

how will you write the same code if data was in another workbook

[@shekayubali1365]

Hi XlvblsFun, If we want to know all the region's using same sheet, how do we need to write the formula

[@ExcelVbaIsFun]

If you know the workbook's names you can reference using workbooks("book1").sheets("sheet1").range("A5") = thisworkbook..sheets("sheet1").range("A5") You may want to check out my basic series videos 13 and 14, which deal with using 2+ workbooks. Let me know if you need more help, i can video it. youtube dot com / watch?v=1iiJL3sj5lI

[@johnahenkorah3748]

In what format should I use the "Greater and equal than" sign if I was to create a SUMIF formula on VBA?

[@halotubb1110]

Thank you sir!!!! You are a God amongst the VBA challenged such as myself. Now if only they had sdDevIfs

[@ExcelVbaIsFun]

Thanks for such kind words. lol, ya that would make things easy. Perhaps you can write your own function for this when you feel up to it. Excel VBA Basics #11 Create your Own Custom Functions with or without Arguments

[@hur0991]

Hello, Where can I download your excel files? Thx.

[@nagarajumididoddi5091]

Hi, i have some doubts please kindly clear it. i have sales data, pin code wise and area head wise in date sheet1, so i want in sheet2, total sale in pin code wise date wise, thourgh VBA code, ( we can use sumifs function also, if i can use sumifs, it will taking more time for updating)

[@excelisfun]

Cool video!

[@b2stbap234]

hi i need to calculate the average by range of dates using vba and i tried using your codes but still cant work. really hope you see this and help

[@TheMilindchankapure]

Hi Your videos is real interesting, can you help me if I wish to do sumifs for range wich are in different workbook and in different worksheet.

[@ExcelVbaIsFun]

Wow! Awesome. Thanks zmyal!

[@miguelqueiroz9614]

Hi Mr. Excel, I'm trying to work with two worksheets, following "video #22 SumIfs using VBA" but no way to make it right. Please advise if you have an earlier video regarging this subject. Thank you and greetings from Brazil.

[@ExcelVbaIsFun]

Hola Miguel! Can you show us the code that isn't working, perhaps we can help! Thanks Dan

[@miguelqueiroz9614]

Should this be enough? Thanks. Sub Soma_Entradas_Caixa() 'Sum Cash(Caixa) entries. Not fine. Dim WRes As Worksheet Dim WCx As Worksheet Dim UltCel As Range Dim vDtIn As Date 'Start date Dim vDtFin As Date 'End date Dim FR As frmDRE Set WRes = Sheets("Resultado") Set WCx = Sheets("Caixa") Set UltCel = WRes.Cells(WRes.Rows.Count, 1).End(xlUp) Set FR = frmDRE Application.ScreenUpdating = False WCx.Select Ln = 3 'Sheets("Caixa") Lin = 11 'Sheets("Resultado") vDtIn = FR.cmbDtSdI.Value 'Start date vDtFin = FR.cmbDtSdF.Value 'End date While WCx.Cells(Ln, 1).Value "" If WCx.Cells(Ln, 1) "" And _ Periodo >= vDtIn And Periodo

[@miguelqueiroz9614]

Anything for me? Thanks.

[@12345Ragde]

Hello, If my criterias come from to two combobox, how I fill in the formula, I mean, I have 2 columns and I need take the values from two combobox, Thanks for share us your knowledge

[@ExcelVbaIsFun]

You can use the ampersand to enter combobox entries together. such as myVar = application.worksheetfunction.sum(me.Combobox1 + 0,me.Combobox2 +0) . hope that helps. Not sure precisely what you're asking. Blessings! Dan

[@alicejohnson9080]

I ave really enjoyed your videos and have been learning a lot. However, where do I find information if we get errors

[@ExcelVbaIsFun]

either do a search for the error number on my channel or email me at [e-mail] and I'll try to provide support as I'm able. Dan

[@nagarajumididoddi5091]

i want sumifs vba code

[@yanyun123cheng]

Hey, you video is very helpful. Thank you. Here is my problem, I used almost the same sentence as you did, but I just cannot to get the total sales // tSales = Application.WorksheetFunction.Sumifs([Price], [Date], ">=" & StDate, [Date], "

[@yanyun123cheng]

It seems I need to use CDbl(EndDate) instead of EndDate only. Still very confusing :(

[@ExcelVbaIsFun]

Evie Cheng Ya, that sounds a little confusing! Did you try downloading the workbook in my dropbox link above? Maybe you can use that as a starting point? Dan

[@sopall4424]

Evie Cheng Thank your for your advice. It helped me a lot !

[@ExcelVbaIsFun]

Hi Evie, You're very welcome! Dan

[@simplyinterpreting]

Here would be good to add a button in the sheet and link it to the function.

[@ThaedJM]

Hi Dan, I've got a problem with using WorksheetFunction.SumIfs. I do a SQL query against a Access db that gets the data and when the query's done I want to print out a few SumIfs. The problem is that the SumIfs don't get all the data. It sums up wrong. Even if I run SumIfs sub again it don't sum up correct. It almost looks like it have the data in a temp memory. Do you have any ideas? Thank you for a great video!

[@ExcelVbaIsFun]

Eek! I'm not familiar with SQL/Access issues. So sorry John. Can you post back any info you may figure out? I just have basic office so I don't actually have access. Sorry dude. Lemme know how it turns out please. Blessings, Dan

[@nahrumamehzabeenpieu132]

Hello, The code keeps showing zero as the result. I have over 1000 data...could this be because of that?

[@ExcelVbaIsFun]

Nahruma Mehzabeen Pieu probably not. It may be a syntax issue or sometimes people have text that looks like numbers ( "938" instead of 938 for example) and that could be why. Can you show us the code or a workbook download link?

[@nyeinchan8491]

I want to study VBA and Macro to be expert,Pls can you train me

[@ExcelVbaIsFun]

Kumar, I'm not sure exactly what you're asking, but I have a basic (getting started) series in Excel's Visual Basic language, that builds from foundational knowledge up so the later lessons make sense. Start out at video 1: youtube dot com/playlist?list=PLw8O1w0Hv2ztGjIkrW7suD6oNDaOk3vbR&feature=view_all Thanks! Dan

[@rajeshmajumdar4999]

Awesome cheers!!!

[@ycaroovoador7744]

👍👍👍 👍👍👍

[@ExcelVbaIsFun]

Thanks Ycaro!

[@printemps92]

Dont work, result 0.Fake ????

[@ExcelVbaIsFun]

Hi printemps92, Sumifs isn't fake, its a worksheetfunction in Excel. If you're having problems, can you paste the code or give us a download link? Thanks Dan

[@KlaydPro]

SAME HERE !!! totalsales = Application.WorksheetFunction.SumIfs([sales], [dateAdded], ">=" & StartDate, [dateAdded], "

[@brianjones7492]

Completely lost me at 6:18, you go into a completely different process, don't explain what you did, or what video I can reference to learn this process. You should have warned us before the video that we would need to now the alt F3 process first.