Excel VBA Sumifs with Multiple Criteria - Macros for Excel

Excel VBA Sumifs with Multiple Criteria - Macros for Excel

Excel Destination

3 года назад

31,688 Просмотров

Ссылки и html тэги не поддерживаются


Комментарии:

Hemanth Kumar
Hemanth Kumar - 21.07.2023 20:46

excellent simple and easy to understand thank you

Ответить
Ali Alizadeh
Ali Alizadeh - 10.11.2022 04:15

Thanx

Ответить
kanhaiya kavathekar
kanhaiya kavathekar - 02.09.2022 10:35

THANK YOU SIR

Ответить
Rsh
Rsh - 21.07.2022 22:38

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

Ответить
Tanner Tucker
Tanner Tucker - 09.02.2022 07:18

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

Ответить
jacquelin gonza
jacquelin gonza - 25.12.2021 02:26

Best tutorial thank you so much

Ответить
Kenny Ramasamy
Kenny Ramasamy - 16.08.2021 14:12

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

Ответить
Makani HaresH
Makani HaresH - 24.07.2021 20:03

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

Ответить
Goda Muleta
Goda Muleta - 28.05.2021 16:40

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

Ответить
Vijay Sahal
Vijay Sahal - 01.05.2021 20:41

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

Ответить
@bh1$h€k
@bh1$h€k - 13.03.2021 21:36

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.

Ответить
MD YOUSUF
MD YOUSUF - 11.01.2021 16:51

Excellent

Ответить
nausheen khalid
nausheen khalid - 17.12.2020 08:13

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

Ответить
shaikh aziz
shaikh aziz - 17.12.2020 05:07

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

Ответить
Bessy Valayil
Bessy Valayil - 28.09.2020 04:54

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

Ответить
Ayan P
Ayan P - 01.08.2020 07:13

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?

Ответить
Nader Mounir
Nader Mounir - 27.07.2020 10:37

Good one 👍 thank you very much

Ответить
Kurt Turner
Kurt Turner - 29.06.2020 15:03

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

Ответить
shivanna H R
shivanna H R - 29.06.2020 03:47

Thanks sir 🇮🇳

Ответить
محمد أبو عبدو
محمد أبو عبدو - 28.06.2020 21:33

Thank You So Mutch, Sir.

Ответить
Vijay Sahal
Vijay Sahal - 28.06.2020 20:34

proper sumifs functions se bnao sir

Ответить
Krishna Group Gzp
Krishna Group Gzp - 28.06.2020 19:58

Mind blowing

Ответить
RAKESH KUMAR
RAKESH KUMAR - 28.06.2020 18:50

Please begging se kraya VBA series wise.

Ответить