Sumifs with Index Match formula in Excel:- Get results from multiple columns

In this video you will learn will learn about you can use sumifs formula with index match to get values from multiple changing columns. You can Download Excel file from below link.
docs.google.co...
Channel link- ‪@ExcellenceInExcel‬

[@RishabhMishra-kn3fv]

Amazing sir

[@ExcellenceInExcel]

Thank you

[@sumankumar7215]

Thanks sir i will try once. May be work successfully 🙏

[@ExcellenceInExcel]

All the best

[@kulchandrathapa]

very useful lesson

[@ExcellenceInExcel]

Thank you

[@rao1097]

Thank you, i was struggling for 2 days

[@ExcellenceInExcel]

Thank You

[@b.r.srihari4099]

Nice presentation

[@ExcellenceInExcel]

Thank you

[@user-gk2pq4pr1f]

Thank you very much 🙏

[@ExcellenceInExcel]

You're most welcome

[@sourabhyadav2916]

Jese hamre pass data hai name ,product, price lekin condition ye hai ki name me table select name se koi bhi name dale to uska product or price dono aana chahiye?

[@ExcellenceInExcel]

Kisi cell me name ka Dropdown bnao or formulae me usi celll ko select kr lo

[@ashishshiriskar123]

nice

[@ExcellenceInExcel]

Thank you

[@imranstar-dr6mu]

Hello please make one video for between two dates or more in same table formats...

[@ExcellenceInExcel]

Check my channel, I Have already made a video, sumifs between two dates

[@imranstar-dr6mu]

same formula mein 2 month ya uss se ziyada month ke liye data ek saath lena hai to kya formula add karna padega....jaise mujhe jan se mar ka data count karna hai to...

[@ExcellenceInExcel]

Use sumproduct formula

[@imranstar-dr6mu]

Aap ne 1. month ka data bataya agar mujhe 2 months ka data ek saath lena hai to????

[@ExcellenceInExcel]

2 months ka data bhi le skte ho aap, index Match me kaise bhi data le skte h

[@imranstar-dr6mu]

same formula mein dusre month ke liye kya formula pass karna padega agar 2 se jyada ka data lena hai to..

[@VisheshKawariya-om1mo]

If I want same formulas between two dates??

[@ExcellenceInExcel]

Yes you can use same formula for that

[@ubaidillahmuhammad20]

Nice. Given excel file

[@ExcellenceInExcel]

thanks, file link shared, you can download from there

[@ubaidillahmuhammad20]

for other video, please all given the files

[@davidsonsunny2886]

Index match is much easier .

[@ExcellenceInExcel]

Thank you

[@devilhunter6762]

How if i want a result from may to nov with name and brand criteria ?

[@ExcellenceInExcel]

for that you have to take range in index formula from may to nov, rest formula will remain the same

[@sandeepchavan455]

Vlookup se rows ki sum kaise kare

[@ExcellenceInExcel]

Please share your question in excel file

[@vinothkumarmanoharan2317]

The way you work, formula works is too bad.. not a proper manner..

[@ExcellenceInExcel]

Thank You for your feedback, will try to explain in more simple manner in my next video

[@vinothkumarmanoharan2317]

@@ExcellenceInExcel I liked your reply bro.. waiting for your more videos about ms office and more early..