I paid for an Excel class that was said to be for beginners to intermediate. I bought it just as a refresher course. Your videos have done so much more than the paid class. Thank you!!!!
@MariyammaThanabalan
Жыл бұрын
I totally agree with your point! He is a great teacher!
@godwinuche4669
3 жыл бұрын
Thank you for your time, good visual, easy to see clearly, you were so gentle in explaining I like this. It makes people from different background to easily understand your speech. Looking forward to more and more excel videos. Well done
@resshmi78
Жыл бұрын
Your method of training/explaining is sooo clear, concise and no-nonsense, thank you so much, this is super helpful.
@Jaypnero
11 ай бұрын
I love the simplicity of your teaching. Thank you so much.
@Michelle-m5u
Ай бұрын
These Videos have helped me more than you know! Super easy to follow and understand! Please keep adding more content! I love them !
@LucaStocchisitiweb
10 ай бұрын
I searched many video to find the solutions, this is the best!
@ReesieMusic
8 ай бұрын
You’re a gentleman and a scholar, thanks!
@TeachersTech
8 ай бұрын
Glad to help
@successqoyo8763
Ай бұрын
Most grateful to you sir!! Two minutes of your video answered my burning question:):):)
@hadijahsulaiman9955
Жыл бұрын
Since I started your teachings I HV a good feeling at any cost but can you do question interviews and answers please. Stay blessed
@Sit93Test
Жыл бұрын
The video was very helpful, thank you for putting it together, the only issue I have is that the subtitle is too big and blocking ones view, especially when you're entering the sumifs functions.
@PaulNye-f8k
6 ай бұрын
Awesome explanation - thank you! I found a few other channels that did not explain this as clearly as you :)
@chadbyrd5577
3 жыл бұрын
Could you add a segment for using AND OR functions within the criteria? Value > 8000 and < 19000
@thambirajahyogarajah4143
2 жыл бұрын
Brilliant Tutorials with fascinating explanations and examples.
@chriswongwp
23 күн бұрын
Thanks for the refresher course. 👏
@asarekodua9489
2 жыл бұрын
So insightful. I really appreciate and enjoyed it👍🏼
@LiuBetty-g6c
3 ай бұрын
I really like your vedio. Just one thing, I can't download the practice stuff from sharepoint
@polygonmap
3 жыл бұрын
Thank you for this! Can we have the worksheet which allows us to edit? Thanks again.
@TeachersTech
3 жыл бұрын
You’re welcome, worksheet ideas in the description.
@fatimaalsaqqaf1102
2 жыл бұрын
thank you for your video. I would like to know what did wanted to find from the SumIfs with 3 criteria is it the "Total sales for the commission of the new costumers are above 20?" because I wanted to apply this on my own data so that I understand the idea itself.
@NGOCNGUYEN-od8wz
2 жыл бұрын
Thank you for a great lesson 🙂!
@theorangutan1914
Жыл бұрын
Excellent video and insight, thank you 👏🏻
@obiageliigweokwu8070
2 жыл бұрын
The tutorial was easy to understand. I have a question, how do i use the sumifs with the same criteria range but using different criteria?
@kyvenchua6626
2 жыл бұрын
thanks for another insightful video! could you also make a video on how to use scenario manager in excel if you haven't already?
@TheoSuperHero
2 жыл бұрын
Very Helpful, Thanks!
@myg14570
2 жыл бұрын
Earlier you posted a functions that automatically adjusts everyday. Is there a way to adjust the period of change? I appreciate your videos so much and thank you!
@jla23
Жыл бұрын
Fantastic explanation, thank you! 🙂
@Sushihead
7 ай бұрын
Amazing, thank you sir!
@Jamie-LeeSampson
17 күн бұрын
Great video!
@broadwaygypsy3304
Жыл бұрын
excellent!! thanks, clear presentation
@ahmedesmat6220
Ай бұрын
VERY USEFUL. THANK YOU
@QasimKhan-gr8yx
2 жыл бұрын
Thank you for such a useful video. I applied the formula but my sum becoming zero somehow :( Please advise
@collinsomoregbe2630
3 жыл бұрын
You're a blessing thank you so much
@leebrendalee
10 ай бұрын
Holy cats are you kidding?. Freaking brilliant, I absolutely cannot thank you enough, clear as mud
@sohamtelang777
15 күн бұрын
Thanks Sir !🤍
@linzixuan29
8 күн бұрын
I keep on getting 1 value for example G1, just G1 so even if it have value for G2 it just doesn’t register. Help
@prakashadhikari7193
3 жыл бұрын
thanks, great example.
@TeachersTech
3 жыл бұрын
You are welcome!
@jeffkabs2394
Жыл бұрын
Hello, I would like to create a workbook for a savings and credit cooperative. This workbook would need to auto-update with years, past, present, and future months. The months would need to range from 2023 to infinite, and the years would need to range from 2023 to infinite as well. The workbook would need to track member id or account names and payments made of deposits, savings, personal accounts, loans received, loan payments, etc. Is this something you can help me with?
@h.delacruz5615
Жыл бұрын
How would someone do a subtraction of a range from a certain cell while using “sumif”
@bladel9
2 жыл бұрын
This is what I am looking for but why is not working on my excel ? =SUMIFS(H6:H400,AN6,S6:S400,"
@0kimbc28
Жыл бұрын
Perfect thanks!
@harrisonkwabenaagyarkwah1570
2 жыл бұрын
How to set up the formula for example if G7=H7+J7 then answer should be equal to 0
@sanjaywilliam6200
3 жыл бұрын
Thank you sir
@sgit1
2 жыл бұрын
Excellent!
@ahsanmohammed1
2 жыл бұрын
Thank you!
@nicolearends9736
5 ай бұрын
Bless you!
@frankbradford9616
Жыл бұрын
well done
@agniveshkadiyala8185
Жыл бұрын
Great !!
@mostafamarey772
Жыл бұрын
Thank you.
@TeachersTech
Жыл бұрын
You're welcome!
@northstardaonuea
Жыл бұрын
Why doesnt this work for me. I get total 0 and I have checked and double checked the formula :(
@peachbusinesssoftware
3 жыл бұрын
Please let me know how you make a video like this, specifically showing a full screen and your face in the bottom left
@TeachersTech
3 жыл бұрын
Here's a tutorial I have: kzitem.info/news/bejne/yYSw26ComqemZ44
@peachbusinesssoftware
3 жыл бұрын
@@TeachersTech Thanks for that. Unfortunately I have just signed up to Filmora after watching one of your videos on that. Do you know if I can do the same in Filmora or is camtasia the only option if I want to make videos like this?
@2Fa2Bu
5 ай бұрын
thanks
@piytube1
2 жыл бұрын
We can easily create sumif formula with the help of excel vba Sub sumif() Range("b9").Value = Application.WorksheetFunction.sumif(Range("a2:a8"), 1680, Range("b2:b8")) End Sub #excel #vba #excelvba #microsoftexcel #microsoftoffice #data #sum #sumif #vbamacro #vbacode #excelformula
@wazmink2459
Жыл бұрын
What is a criteria? How can I identify a criteria?
@arisu229
3 ай бұрын
sum ifs are kinda weird. i don't know why it became $4800, but okay...??
Пікірлер: 63