Excel VBA Sumifs with Multiple Criteria - Macros for Excel

Excel VBA Tutorial with Explanation of VBA Code to use Sumifs in Excel with multiple Criteria.

[gerberadaily]

Nice. Very detail step by steps for newbie like me. Thank you for the video.

[hemanthkumar]

excellent simple and easy to understand thank you

[dayanandsakat-bm]

Great Sir super everything is good. Thank you so much

[RoshanDrummer]

Will this method also make the calculation time faster compared to the manual formula?

[makaniharesh]

Can we use this for 50k plus rows for results data

[MegaWarriors]

Thanks fr this can I do a difference using the same formula . I have to group and do a difference on two columns

[tannertucker]

Thank you. This is very good. Can sumifs be used with OR criteria?

[kurtturner]

can you use data validation drop downs for product name and city, so you don't have to type?

[ayanp]

Hey, thanks a lot for this. For a specific use-case of mine, I need to pass multiple criteria for a single column and then have it summed. Can you please help me with the VBA macro for the same?

[bessyvalayil]

Good info. Could you give the code to access the same data from a .csv file?

[godamuleta]

Dir instructor what you have thought us is a simple general summation of data do you think this describes sumifs ?

[abhishekdsl]

Thanks for the great tutorial. Can you tell me how to populate this formula in more than one cell in col H, for eg. from cell H2 to H50 or so on for the combination of multiple products and cities. Also if I want to update the formula automatically in subsequent columns each month, how can that be done. For eg. if col H shows Feb data then col i should show Mar(current month) data and so on if every month I have to update it with current month data. Next month col J should show Apr month data at the click of macro button while the data in col h and i remain as it is. Sorry if my question is too confusing.

[vijaysahal]

hi sir jo excel main sumifs formula apply hota h waise hi normal sumifs per vba main blog bnao sir

[shaikhaziz]

Sir, it's a very great video with simple language explanations, by your code i think i also get resolve my data set vba...i have N numbers of states name in column B and based on states name i want to merge column E...

i think i should use product key as a states name only instead of .value i must use .merge ...pls suggest any code for above criteria. thankyou so much

[kennyramasamy]

Hi I need help with excel vba code to add multiple sheets and move down to the next cell down the column for the next day’s quanity

[nausheenkhalid]

Plz help in volumn f i want to write full set of criteria instead only football and in coumn h i want sum againts each criteria with one click. Plzzzz tell me

[RAKESHKUMAR-qwcn]

Please begging se kraya VBA series wise.

[dayanandsakat-bm]

Thanks for better understanding vba code kindly share contact no