Excel VBA Sumifs with Multiple Criteria - Macros for Excel

[@gerberadaily]

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

[@hemanthkumar80]

excellent simple and easy to understand thank you

[@dayanandsakat-b1m]

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?

[@kurtturner5120]

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

[@ExcelDestination]

yes, we can do that also. It will work.

[@godamuleta7656]

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

[@MegaWarriors24]

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

[@jacquelingonza9685]

Best tutorial thank you so much

[@ExcelDestination]

You're welcome!

[@ayanp343]

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?

[@ayanp343]

Actually I figured a way using the new "Filter" formula in Excel 2016.

[@makaniharesh1459]

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

[@tannertucker22]

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

[@MohAboAbdo]

Thank You So Mutch, Sir.

[@nadermounir8228]

Good one 👍 thank you very much

[@ExcelDestination]

Most welcome 😊

[@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.

[@ExcelDestination]

for any excel vba project, please send email to [e-mail]

[@krishnagroupgzp2641]

Mind blowing

[@ExcelDestination]

Thanks

[@shaikhaziz9703]

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

[@ExcelDestination]

Thanks. For any real project requirement, you can write to [e-mail]

[@shaikhaziz9703]

@@ExcelDestination okay i will do mail samples sir...thankyou

[@kennyramasamy6897]

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

[@bessyvalayil1831]

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

[@MDYOUSUF-tl8sk]

Excellent

[@ExcelDestination]

Thank you so much 😀

[@nausheenkhalid3761]

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

[@kanhaiyakavathekar9058]

THANK YOU SIR

[@ExcelDestination]

Welcome

[@shivannahr780]

Thanks sir 🇮🇳

[@alializadeh8195]

Thanx

[@vijaysahal4556]

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

[@RAKESHKUMAR-qw9cn]

Please begging se kraya VBA series wise.

[@ExcelDestination]

ok

[@vijaysahal4556]

proper sumifs functions se bnao sir

[@dayanandsakat-b1m]

Thanks for better understanding vba code kindly share contact no