Sumifs with Index Match formula in Excel:- Get results from multiple columns
HTML-код
- Опубликовано: 11 сен 2024
- 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
Amazing sir
Thank you
Thanks sir i will try once. May be work successfully 🙏
All the best
very useful lesson
Thank you
Thank you, i was struggling for 2 days
Thank You
Nice presentation
Thank you
Thank you very much 🙏
You're most welcome
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?
Kisi cell me name ka Dropdown bnao or formulae me usi celll ko select kr lo
nice
Thank you
Hello please make one video for between two dates or more in same table formats...
Check my channel, I Have already made a video, sumifs between two dates
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...
Use sumproduct formula
Aap ne 1. month ka data bataya agar mujhe 2 months ka data ek saath lena hai to????
2 months ka data bhi le skte ho aap, index Match me kaise bhi data le skte h
same formula mein dusre month ke liye kya formula pass karna padega agar 2 se jyada ka data lena hai to..
If I want same formulas between two dates??
Yes you can use same formula for that
Nice. Given excel file
thanks, file link shared, you can download from there
for other video, please all given the files
Index match is much easier .
Thank you
How if i want a result from may to nov with name and brand criteria ?
for that you have to take range in index formula from may to nov, rest formula will remain the same
Vlookup se rows ki sum kaise kare
Please share your question in excel file
The way you work, formula works is too bad.. not a proper manner..
Thank You for your feedback, will try to explain in more simple manner in my next video
@@ExcellenceInExcel I liked your reply bro.. waiting for your more videos about ms office and more early..