@leilagharani Kindly help me with this problem. My boss is eating on creating an analysis table. The call time is eg. 8:24:55 AM and 5:44:67 PM, I need only the hour from here. But hour function is used but for pm it is showing in 24 hours format. But they want in number format only. How can I do it. The formula mention in the shet was numbervalue.. I'm not getting it with that formula please help..
Leila you have saved me so many tears these past months. I´ve got a task from my boss to make a 5 year-budget for the whole department in EXCEL and your tutorials have just helped so much!
I was here trying to learn SUMIFS but turned out I learned; - AVERAGEIFS - COUNTIF - COUNTIFS - how to put > or < and " into the formula interchangeably - and how to transform data into an Excel table with ease I don't get why a hundred people gave her dislikes but this sure is one of the best Excel how-to video!!
Hi Leena , Please can you tell my how can i count a particular text in a column excluding certain rows , eg rows s2:s500 and count rows that say on track excluding text in row s4 / s13/s18
@@mildredsouza5907 how about if while you use the formula, you press CTRL and count it individually 1 by 1.. I mean some kind like this =countif((s2:s12)+countif(s14:s17)+countif(s19:s500))
Leila, you are truly an inspiration to us all. Your excellent Excel videos saved my career. I cannot adequately thank you enough for everything. I am beyond forever grateful to you for the lecture videos. Looking forward to your future videos that are ALWAYS easy to understand.
Though Leila's videos are here on UA-cam for years now but I noticed those only today. I don't know how many characters this UA-cam comment area allows so I can endorse her work with the words those she deserves. I'm in the software field for the last 30 years but haven't seen such a tutor and neither I bothered to go out and start appreciating someone in this comment area. She is The Teacher, The Mentor, and let me say The Lady :) of course. Just Superb. Well done Leila!
Your videos are so amazing! Every time you teach me a new function and show how fast excel can get the results - I have to pause the video because I'm just stunned! Wow! I feel like I'm watching a wizard reveal her deepest secrets
Wow! I went from using: =SUMPRODUCT((LEN(B2:31)-LEN (SUBSTITUTE ((B2:B31),K1,"")))/LEN (K1)) to using: =COUNTIFS(B2:B31,"*"&K1&"*") I was also able to start using * for many other equations! Thanks so much for this informative video!
I've watched most of your videos if not all... I owe a lot my knowledge in making financial performance reports of my clients not just faster to accomplished but most importantly in quality outputs. You are one of my Excel mentors and I will forever be grateful of that. Again thank YOU so much...to you, other brilliant excel tutors and to UA-cam for this new platform of learning that is truly beneficial to people around the world. You've given us an access to the technology and innovations not just applicable to finance, accounting and business people but so many other important learning tools making complicated things and sitiations not just solved but solved faster. More power Ms. Leila.
Wow, I really appreciate the kind feedback. It's so great to hear that you could take this knowledge to improve your work. Thanks for the support and keep learning :)
Leila, you are a genius. I have used spreadsheets for years but in a really basic way - sum columns, subtotals etc. I started using MacNumbers and hit precisely the problem you showed: how do I populate cells with the results of several criteria. I could on the Sumif and that saved time. But I was trying functions like "AND" and could not get it to work. Then I wondered what the difference was between Sumif and Sumifs. I couldn't find anything (for MacNumbers) on it. Then I watched your video and kapow! The Mac worked in exactly the same way. Gone are the time consuming days of adding columns and transferring the results to a cell. Now, thanks to you, I can create a table how I want it and use Sumifs to populate the cells. Here's a virtual kiss on the hand and a big THANK YOU. Liked and subscribed.
I'm a relative novice to using Excel, and I find these functions to be a bit intimidating to master, HOWEVER, even I find this tutorial quite easy to understand and digest. I just became your subscriber. Thanks for this!
That's great to hear. Thanks for the support. Agree - Excel functions are intimidating at first but they are lots of fun when you get to know them better :)
BTW, technically speaking, "Find out how many shirts were sold for the below criteria:" is incorrect, right? Because you're not trying to figure out the actual amount of shirts that were sold.
Thanks a lot Leila, I liked your explanation very much, specially the reason why we shall not use SUMIF anymore but SUMIFS and the TABLES explanation at the end. Regards from Brazil !
Many thanks for the explanation @Leila Gharani . I bumped into this when I was looking for a video on sumif. I am faced with a situation and it can be achieved by sumif/sumifs. An example of the data in Spreadsheet Date Team Possession 17/Sep/2023 Arsenal 75 17/Sep/2023 Everton 25 21/Sep/2022 Arsenal 59 21/Sep/2022 PSV 41 24/Sep/2022 Arsenal 46 24/Sep/2022 Tottenham Hotspur 54 The first column is Date, the second is team and the 3rd column is Possession. Note that the Date is repeating for 2 rows. The 2nd column is Team and it gets repeated in alternate rows. The third column is Possession. The problem statement: I want to create a formula such that whenever I enter a value for field i.e. the possession, the same field for the same date should be auto-populated by (100-the value entered in the other cell) such that the total of the 'Possession' field is 100%. I think I am able to explain. Could you help me achieve this simple automation ?
GOT AN "A" IN MY MIST CLASS BASED PRIMARILY ON EXCEL....I HAVE NO ONE BUT YOU TO THANK. THANKS A MILLION LEILA YOUR VIDEOS ARE A BLESSING FOR STUDENTS LIKE US
I have a strong understanding of basic spreadsheet formulas, but I've been searching all day today for a formula which will allow me (as a stock market trader) to calculate the average spread (the difference between an asset's sell price and its buy price at the time of purchase), but ONLY with regards to my trades which have ended up being profitable and then I wanted another average spread calculation for trades which were NOT profitable, so which factors in the binary 1's and 0's in my profit and loss columns. You've just solved this problem for me and taught me something extra about spreadsheets. Thank you!
Leila, thank you so much! My team and I are building a histogram for a cruise line company’s spare parts list and we needed to find out how many vessels would receive the parts they ordered within a range of timeframes. The COUNTIFS function helped me do that easily and efficiently!
Amazing lecture Leila your speed of talking is exactly what someone need to absorb new information form a lecturer You amaze me the more I watch your videos
1,110 days on from the release of this video, and the fairly recent introduction of dynamic arrays has really got me thinking about how I write formulas! One of the issues I find with functions like SUMIFS and COUNTIFS is that they don't allow for OR conditions or multiple column arrays. Even doing a conditional SUMPRODUCT with ranges that span over two columns will result in an error. This is where I've found *SUM(IF(…* or *COUNT(IF(…* formulas to be really useful because they provide a lot more flexibility. I think before - there was a reluctance to use formulas like this because you had to press Ctrl + SHIFT + RETURN. Now it just feels a lot better.
Thanks for the tutorial. Just a note for everyone, if you are using merged cells, you need to treat them as single cells in the formulas ranges e.g. if you had A1 merged to C1 for criteria_range1, and you selected 4 rows Excel will treat this as A1:C4, but this will cause the formula to error with #VALUE!, just change the the range to A1:A4 and this will work. This took me a while to figure out why my formula would not work.
Thank you Leia! I couldn't do these in my job excel assessment test. I am now prepared for next time. Your video is the best explaining these functions!
WOW! What an explanation I really understood the entire logic behind the story and thanks for uploading such lovely videos hope to watch more of such a great lectures.
Leila, you explained this so wonderfully. Like, the small details mattered such as when to click the criteria and where to FIND THAT criteria. It just made it so easy to understand. Please keep it up! Thank you!!
Thanks for your video. I learn a lot. I recently started using the if function and enjoying it. Let me give you a scenario: A is Low Risk 0 - 19%, B is Lower Risk 20% - 39%, C is Medium Risk 40% - 59%, D is High Risk 60% - 79%, E is very High Risk 80% - 100%. For each one, I do an IF function for True and False. The very formula gives me a "True". I use =. Here is my formula: =IF(AA6
thank you so much Leila, you helped me figure out how to sumifs using multiple criteria, and not having to use range/table complexity. THANK YOU so much!
countif just saved me hours -- Thank you so much ! The instruction is easy to understand, and examples can be applied easily to any situation. Again, thank you so much.
@@peteradeteacher1380 the video in your link was not well done and almost impossible to understand through the accent, and it's rather tacky to add links for your own page, when Leila has worked very hard to establish herself, and many of us watch her video's regularly
You are soo good Liela .. absolute clarity on what you teach . Every video has at least 3-4 takeaways which help me speed up excel working ... been using SUMIF for ages .... willl switch to SUMIFS immediately !
Leila, I don't know where I should Post this Question...so - here goes! Here's one - first off - is the Following a "Viable" Algebra Equation: "If Current Stock Price is "X" and Average Cost is "Y" With Difference in Prices = "Z" and Stock Quantity Currently = "A", Let "B" = # Of Shares to Buy - To make Difference = to |1 Cent|, & C = Net Cost to Buy" *Note - the "|1 Cent|" Value may be changed, to suit the desired Interest. I guess it also could be a Variable, like ?D? So - can this be properly expressed in an Algebraic Equation? Or - does it require a Different "Math" Tool - to "Lay it out?" Goal - To determine a Factor - to make the equation work - an Numerous different Values for X, Y, and B. (Z is just the Difference of X & Y; and C is just the Factor of Calculating B times X.) Currently - I see the "B" can be worked out - in a series of Testing Steps, Forward, But - I am seeking to work in out, via a Set Formula (in Excel 2007, in my case), in a More or Less "Automatic" Fashion, rather than a lengthy "Trial, Verify - Fail, Adjust, Trial.... Etc. Well - that said. Enjoy!
Grab the file I used in the video from here: pages.xelplus.com/sumifs-file
@leilagharani Kindly help me with this problem. My boss is eating on creating an analysis table. The call time is eg. 8:24:55 AM and 5:44:67 PM, I need only the hour from here. But hour function is used but for pm it is showing in 24 hours format. But they want in number format only. How can I do it. The formula mention in the shet was numbervalue.. I'm not getting it with that formula please help..
@@vichu847468 Use the text function like this "TEXT(A1,"hhh")" and it will return the hour in number format.
Leila you have saved me so many tears these past months. I´ve got a task from my boss to make a 5 year-budget for the whole department in EXCEL and your tutorials have just helped so much!
I'm happy to hear that Vanesa!
@@LeilaGharani ok
Thanks
I was here trying to learn SUMIFS but turned out I learned;
- AVERAGEIFS
- COUNTIF
- COUNTIFS
- how to put > or < and " into the formula interchangeably
- and how to transform data into an Excel table with ease
I don't get why a hundred people gave her dislikes but this sure is one of the best Excel how-to video!!
I've been struggling with SUMIF(s) all morning, this sorted my issue out immediately, thank you for sharing your knowledge!
I'm glad it was helpful!
Hi Leena ,
Please can you tell my how can i count a particular text in a column excluding certain rows , eg rows s2:s500 and count rows that say on track excluding text in row s4 / s13/s18
Mee too
@@mildredsouza5907 how about if while you use the formula, you press CTRL and count it individually 1 by 1.. I mean some kind like this =countif((s2:s12)+countif(s14:s17)+countif(s19:s500))
@@mildredsouza5907 i found farmula better than countifs watch and decide may its help you
ua-cam.com/video/Uw5MiEEA_3A/v-deo.html
OMG, you are so good at explaining. I prepare a monthly report for my client using pivots. I stopped using pivots. Now I use SUMIF. Thank you so much.
Leila, you are truly an inspiration to us all. Your excellent Excel videos saved my career. I cannot adequately thank you enough for everything. I am beyond forever grateful to you for the lecture videos. Looking forward to your future videos that are ALWAYS easy to understand.
I'm really glad you like the videos!
Though Leila's videos are here on UA-cam for years now but I noticed those only today. I don't know how many characters this UA-cam comment area allows so I can endorse her work with the words those she deserves. I'm in the software field for the last 30 years but haven't seen such a tutor and neither I bothered to go out and start appreciating someone in this comment area. She is The Teacher, The Mentor, and let me say The Lady :) of course. Just Superb. Well done Leila!
Wow, thank you very much for the feedback. Makes me very happy :)
Excellent tutor, you explain fumula so clearly thank you Leila!
Thanks for this value information
you saved me
ill watch all the rest
your way is simple to understand
Your videos are so amazing! Every time you teach me a new function and show how fast excel can get the results - I have to pause the video because I'm just stunned! Wow! I feel like I'm watching a wizard reveal her deepest secrets
Excellent tutor, made things very simple and easy, thank you!
Very happy to hear that Jerry. You are very welcome.
Wow! I went from using:
=SUMPRODUCT((LEN(B2:31)-LEN (SUBSTITUTE ((B2:B31),K1,"")))/LEN (K1))
to using:
=COUNTIFS(B2:B31,"*"&K1&"*")
I was also able to start using * for many other equations! Thanks so much for this informative video!
Great job!
Thanks Mam for sharing ur knowledge of Excel with us so we can too Excel in Excel.Thaks a lot.... and keep sharing....
You're very welcome Shiva. It's my pleasure. Thank you for your nice comment & your support.
I've watched most of your videos if not all...
I owe a lot my knowledge in making financial performance reports of my clients not just faster to accomplished but most importantly in quality outputs.
You are one of my Excel mentors and I will forever be grateful of that.
Again thank YOU so much...to you, other brilliant excel tutors and to UA-cam for this new platform of learning that is truly beneficial to people around the world. You've given us an access to the technology and innovations not just applicable to finance, accounting and business people but so many other important learning tools making complicated things and sitiations not just solved but solved faster.
More power Ms. Leila.
Wow, I really appreciate the kind feedback. It's so great to hear that you could take this knowledge to improve your work. Thanks for the support and keep learning :)
@@LeilaGharani ❤❤❤Thank You!!!❤❤❤
Hi Leila, really I am a fan of your videos and techniques, and keep watching...thank you
Leila, you are a genius. I have used spreadsheets for years but in a really basic way - sum columns, subtotals etc. I started using MacNumbers and hit precisely the problem you showed: how do I populate cells with the results of several criteria. I could on the Sumif and that saved time. But I was trying functions like "AND" and could not get it to work. Then I wondered what the difference was between Sumif and Sumifs. I couldn't find anything (for MacNumbers) on it. Then I watched your video and kapow! The Mac worked in exactly the same way. Gone are the time consuming days of adding columns and transferring the results to a cell. Now, thanks to you, I can create a table how I want it and use Sumifs to populate the cells. Here's a virtual kiss on the hand and a big THANK YOU. Liked and subscribed.
Thank you Leila
Very smart & useful Excel techniques.
You're very welcome Hattem :)
Hattem
I'm a relative novice to using Excel, and I find these functions to be a bit intimidating to master, HOWEVER, even I find this tutorial quite easy to understand and digest. I just became your subscriber. Thanks for this!
That's great to hear. Thanks for the support. Agree - Excel functions are intimidating at first but they are lots of fun when you get to know them better :)
BTW, technically speaking, "Find out how many shirts were sold for the below criteria:" is incorrect, right? Because you're not trying to figure out the actual amount of shirts that were sold.
Hi - actually yes - we need to count how many were sold here...
Great video! SUMIFS and the like are so powerful!!! And fun too : )
So True! Thank you Mike.
Thanks a lot Leila, I liked your explanation very much, specially the reason why we shall not use SUMIF anymore but SUMIFS and the TABLES explanation at the end. Regards from Brazil !
Glad you like it Marcio.
This is a great refresher! Thank you, Leila!
Many thanks for the explanation @Leila Gharani . I bumped into this when I was looking for a video on sumif. I am faced with a situation and it can be achieved by sumif/sumifs.
An example of the data in Spreadsheet
Date Team Possession
17/Sep/2023 Arsenal 75
17/Sep/2023 Everton 25
21/Sep/2022 Arsenal 59
21/Sep/2022 PSV 41
24/Sep/2022 Arsenal 46
24/Sep/2022 Tottenham Hotspur 54
The first column is Date, the second is team and the 3rd column is Possession. Note that the Date is repeating for 2 rows.
The 2nd column is Team and it gets repeated in alternate rows. The third column is Possession.
The problem statement: I want to create a formula such that whenever I enter a value for field i.e. the possession, the same field for the same date should be auto-populated by (100-the value entered in the other cell) such that the total of the 'Possession' field is 100%.
I think I am able to explain. Could you help me achieve this simple automation ?
THANK YOU
You're very welcome.
GOT AN "A" IN MY MIST CLASS BASED PRIMARILY ON EXCEL....I HAVE NO ONE BUT YOU TO THANK. THANKS A MILLION LEILA YOUR VIDEOS ARE A BLESSING FOR STUDENTS LIKE US
That's great Natasha. Congratulations!
i don't trust people who can work with excel
😅lol, that can lead to a world debate.
Oh my gosh I've started a new job and I need to learn it, alongside everything else to learn...I'm so intimidated and they can sense I suck already 😅
Then consider yourself an idiot person. 😂
@cleamahon4277 I'm preparing for a final exam & I've just now started to get the hang of this....I think? 😅
Well we being forced to learn 😂😂
I have a strong understanding of basic spreadsheet formulas, but I've been searching all day today for a formula which will allow me (as a stock market trader) to calculate the average spread (the difference between an asset's sell price and its buy price at the time of purchase), but ONLY with regards to my trades which have ended up being profitable and then I wanted another average spread calculation for trades which were NOT profitable, so which factors in the binary 1's and 0's in my profit and loss columns. You've just solved this problem for me and taught me something extra about spreadsheets. Thank you!
You're very welcome! I hope a lot was in the profitable column :)
You have a gift! You make the seemingly complicated, remarkably simple. Now demystified Sumifs, countifs, Averageifs for all of us. Thanks Leila!
You're very welcome. Many thanks for the kind feedback!
Many videos but this gave me complete all details...................Your teaching is giving me idea of exploring functions in different ways Thanks
Leila, thank you so much! My team and I are building a histogram for a cruise line company’s spare parts list and we needed to find out how many vessels would receive the parts they ordered within a range of timeframes. The COUNTIFS function helped me do that easily and efficiently!
Amazing lecture Leila your speed of talking is exactly what someone need to absorb new information form a lecturer
You amaze me the more I watch your videos
I'm glad you find it easy to follow Kamel : )
Come here looking for sumifs, turned out getting a lot more of useful information about excel. Thank a lot Leila, Good Luck
Glad it was helpful!
Very soft and polite way of teaching is the best tool for her. Nice and excellent videos on the other topics too.
Thank you! Glad you like the videos :)
You are most welcome. You deserve to be appreciated for your work. It is free for learners. Keep going.
HEBAT HEBAT!!! Pinter banget. Thank you Leila! Your videos are very helpful. Amazed.
1,110 days on from the release of this video, and the fairly recent introduction of dynamic arrays has really got me thinking about how I write formulas!
One of the issues I find with functions like SUMIFS and COUNTIFS is that they don't allow for OR conditions or multiple column arrays. Even doing a conditional SUMPRODUCT with ranges that span over two columns will result in an error. This is where I've found *SUM(IF(…* or *COUNT(IF(…* formulas to be really useful because they provide a lot more flexibility.
I think before - there was a reluctance to use formulas like this because you had to press Ctrl + SHIFT + RETURN. Now it just feels a lot better.
Don't know what you talking about but I will experiment it out
Thank you...Excellent Tutorial. Namaste from India.
Thanks Leila for going slow so that the brain can grasp fully, you are the bestest teacher!!
OMG OMG, I CAN'T EXPRESS HOW MUCH YOUR VIDEOS ARE SAVING MY LIFE!!!, EVEN AN OLD VIDEOS, THANK YOU VERY MUCH :)
Happy to hear that!
Thanks Ms Leila. These videos are very useful. Your style of tutoring is superb. To the point. Well designed examples. Namastae.
Glad it was helpful!
Leila, thank you for making my work easier and more productive! You deliver the information quickly and it is so much more information than expected!
Very Nice illustrated, very fast and simply understandable ... Good Madam... Thank you very much ..
You are most welcome
Thanks for the tutorial.
Just a note for everyone, if you are using merged cells, you need to treat them as single cells in the formulas ranges e.g. if you had A1 merged to C1 for criteria_range1, and you selected 4 rows Excel will treat this as A1:C4, but this will cause the formula to error with #VALUE!, just change the the range to A1:A4 and this will work. This took me a while to figure out why my formula would not work.
Thanks for the input Chris! One more reason to avoid merged cells :)
Thanks alot I was having too many problems with SUMIFS , now every thing is more than OK , Thanks
Glad to help.
@@LeilaGharani Thanks really you make Excel for me clear and simple
Explain very thoroughly- its too good
Really your teaching method is excellent..proud of you Leila
@Leila Gharani You have covered subtle details and possible mistakes in very simplified way, it saved my day.
Great job and Thanks
Thanks for spreading knowledge
Excellent Videos. Very thorough and complete!
Much appreciated, George!
Very useful for developing habit of reducing manual work and automate task. Thanks Leila. Expecting more from you.
You are welcome 😊
Laila you are a great teacher.... lots of hearts for u
Great Video. Helped me to fix my spreadsheet error.
Thank you Leia! I couldn't do these in my job excel assessment test. I am now prepared for next time. Your video is the best explaining these functions!
Thank you for excellent easy explanation
WOW! What an explanation I really understood the entire logic behind the story and thanks for uploading such lovely videos hope to watch more of such a great lectures.
Leila, you explained this so wonderfully. Like, the small details mattered such as when to click the criteria and where to FIND THAT criteria. It just made it so easy to understand. Please keep it up! Thank you!!
I'm very glad to hear that Adil! Thanks for your feedback and your support.
Excel formulas are hard to understand, but you explained it really good Thank you mam.
Glad to hear that
¡Gracias!
Thank you!
your videos are a blessing
I'm glad to hear that Alexandra :)
You are the best!!! You're videos never pass out!! Just learn how to condition the formula to a cell...
Thanks for your video. I learn a lot. I recently started using the if function and enjoying it. Let me give you a scenario: A is Low Risk 0 - 19%, B is Lower Risk 20% - 39%, C is Medium Risk 40% - 59%, D is High Risk 60% - 79%, E is very High Risk 80% - 100%. For each one, I do an IF function for True and False. The very formula gives me a "True". I use =. Here is my formula: =IF(AA6
you can go for conditional formatting
thank you so much Leila, you helped me figure out how to sumifs using multiple criteria, and not having to use range/table complexity. THANK YOU so much!
Hie Leila Gharani, your videos are very helpful. Full of content you're merely a humble tutor
Wow, i have struggled to understand this formulars and you have made so easy for me to understand. Thanks for sharing.
Glad it was helpful!
@@LeilaGharani , am searching for more of your videos now. thanks again.
It's a nice and very useful video.your teaching is very good .thank You madam
One of the best excel videos I have seen so far, wow moment for me ma'am. Please do a series on all financial formulas.
Thanks for the kind feedback. Really glad you like it.
Please do a series on all financial formulas too
indeed, the way you explanation is one of the best source i have ever noticed. You are really great!
I'm happy to hear that Mohammad.
@@LeilaGharani ❣❣❣❣👍👍👍
Honestly speaking it is the most simplest explanation ever. Thank You. Great video.
You're welcome. Glad you like it.
Thank you Leila. You make some of the best Excel videos out there. And I could listen to your voice all day ;)
I'm glad to hear that :)
countif just saved me hours -- Thank you so much ! The instruction is easy to understand, and examples can be applied easily to any situation. Again, thank you so much.
true. check this ones too. and dont forget tolike n subscribe
ua-cam.com/channels/VZha-RnaYA9ALGgirEYXIg.html please dont forget to like n subscribe
Also try dcount farmula better than countifs
ua-cam.com/video/Uw5MiEEA_3A/v-deo.html
@@peteradeteacher1380 the video in your link was not well done and almost impossible to understand through the accent, and it's rather tacky to add links for your own page, when Leila has worked very hard to establish herself, and many of us watch her video's regularly
Great Learning Madam . Looking forward for more useful videos. Regards
Thank you Leila, you are truly a tutor. You explained so clearly I'm impressed.
Glad you think so!
Excellent tutorial, I now know how to perform SUMIFS, AVERAGEIFS and COUNTIFS. You helped me to understand the steps to take. Thank You!
I'm glad to hear that Wynne. You're very welcome :)
Thank You! Your videos are very helpful
Your explanation is simply THE BEST!!
I'm very happy to hear that!
Thanks Leila Gharani……. I saw your several videos which connects with excel functions and It has been very helpful to me.
...!
.
You're very welcome. I'm glad the videos are helpful!
Great job - well presented
Very very very clear explanation! I always had issues understanding this function completely, now I'm expert! Thank you so much!
You're very welcome!
Thanks Leila....you just made excel sweeter to use!!!
Love this video, wonderful information for working professionals, lots of from India for you.
Glad to hear that :)
You are soo good Liela .. absolute clarity on what you teach . Every video has at least 3-4 takeaways which help me speed up excel working ... been using SUMIF for ages .... willl switch to SUMIFS immediately !
Thanks a ton! I was looking for Countifs formula with 3 criteria since last 2 days and finally I got it here :)
Glad it helped!
Excellent class Leila !!!!!!
After watching many videos I finally understood how to use SUMIFS and the logic behind it.Thank you x
Glad to help!
Nice, short and to the point plus cheerful personality 😊👍👌
Glad you like it :)
I am from Bangladesh So much useful and learning strategy is very nice. Thank you so much dear.
Leila, you are my best teacher, you helped me always and still..God Bless You....
OMG TQSM!! IVE BEEN SEARCHING MANY VIDEOS TO UNDERSTAND THIS FX FOR WEEKS IN ORDER TO SUBMIT MY PROJECT TO MY LECTURER 😭
I'm using Libre Office and this is very clear indeed. Well presented.
Glad you like it.
u r my new teacher
Leila, I don't know where I should Post this Question...so - here goes!
Here's one - first off - is the Following a "Viable" Algebra Equation:
"If Current Stock Price is "X" and Average Cost is "Y" With Difference in Prices = "Z" and Stock Quantity Currently = "A", Let "B" = # Of Shares to Buy - To make Difference = to |1 Cent|, & C = Net Cost to Buy"
*Note - the "|1 Cent|" Value may be changed, to suit the desired Interest. I guess it also could be a Variable, like ?D?
So - can this be properly expressed in an Algebraic Equation? Or - does it require a Different "Math" Tool - to "Lay it out?"
Goal - To determine a Factor - to make the equation work - an Numerous different Values for X, Y, and B.
(Z is just the Difference of X & Y; and C is just the Factor of Calculating B times X.)
Currently - I see the "B" can be worked out - in a series of Testing Steps, Forward, But - I am seeking to work in out, via a Set Formula (in Excel 2007, in my case), in a More or Less "Automatic" Fashion, rather than a lengthy "Trial, Verify - Fail, Adjust, Trial.... Etc.
Well - that said. Enjoy!
I’ve used the SUMIFS function before but just got stuck this morning. This refresher unblocked my brain! Thank you!!
Awesome work.
Very clear explanation, thanks so much.
I have a test tommorow, this video has helped me alot
Good luck!
I was fortunate to find this video on the use of wildcard searches, and used that with your video about the use of COUNTIFS. Thank you!
Very useful lecture, thanks.
Thank you so much i understand sumifs much better
Amazing video 👌🏿
Well explained Leila. I learnt a lot
Glad the tutorial was helpful.
That's called a real tutorial . Love from india .
Glad you like the video!