All Teachers tech videos have helped me understand excel better. It was so intimidating especially with formulas. Even though I still get confused with my work spreadsheets, I'm getting there day by day.
Thank you Thank you!!! This was very helpful for my project. It helped that you reviewed multiple methods and both SUMIF and SUMIFS. Exactly what I needed. 🤩
Very helpful, I was wondering if you could make a short video on how to take a block of cells , that are not a header or footer and freeze them to move with the page up and down. If you could that would be great thank you.
Another great job on this video, Jamie. Thanks. I am having an issue with getting circular reference errors. Maybe I am not coding the correct formula? I am new to using Excel (less than a month). Can you please do a video on this? I am taking 2 columns and subtracting a 3rd and placing the results in another column. Call them A+B-G results in column M. Now, I need to use the results in M and multiply that by column O which is a percentage and place those results in column B. Is this possible? Is that the problem? When I copy the formula down in B, I get a blue arrow connecting columns on other rows with the error dialog box popping up saying I have a circular reference. Am I not allowed to use the results of one calculation to create another calculation? Is it trying to do the multiplication before the addition so that the value in M is non-existent? Must I have these columns adjacent to each other or can they be spread out over the sheet as they are? I have been working on this for days, am I making sense? Please help? Thanks.
Can “countif wildcards” be applied for data across multiple worksheets? For example, I want to determine how many times a name appears in a current worksheet and all other previous worksheets.
Hi Jamie, thanks for this, it was inspiring to say the least! I was wondering if you could help (this maybe down to my own understanding or lack of it, rather than your clip). I am working on a spreadsheet and I need to find a formula that demonstrates if a number greater than 0 appears in more than 1 cell, for example in a football game, Team A V Team B, the final result is 2-1 and so Team A have won. What I need to identify is if that both teams have scored then the formula would display a result as YES or NO, or 1 or 0. Can you help?
You said you dropped the practice file link so we can download and follow along in this lesson. I couldn’t find it anywhere here in the description below
Practice sheet: leveragingdigitalinc-my.sharepoint.com/:x:/g/personal/jamie_leveragingdigital_com/ERb6QtZDTfpLn11fzdmex6cBORS5L2IyljE9CviTaA259Q?e=rdkeUv
Question I have a drop-down menu in my spreadsheet I used the Countif Function to count the total of the item now I am trying to Subtract from that item when drop down is listed as deployed Example =COUNTIF('Inventory List'!E5:E209,"p135g")-COUNTIF('Inventory List'!B5:B360,"deployed") Keep Getting 0
I'm trying to get a simple COUNTIFS formula to work where if G3 is greater than 59 and G4 is "Over" it counts 1, BUT I need to do that for multiple sets(ie.G6 is greater than 59 and G7 is "Over"...G9 is greater than 59 and G10 is "Over"...etc. and give me a count for all of those instances. I tried the following but it counts "0" (=COUNTIFS(G3:G56,">59",G3:G56,"Over").
DOES ANYONE KNOW....How do we count the number of cells in a range that have a hyperlink that was entered via the 'insert link', and that also have text displayed in the cell? The link isn't in the cell display, which is how all your examples work.
Head Name Count A peter yes A will no B peter no B will yes A mark yes B mark yes A peter no B mark no This above said details are my Data. But i want following type of results. Head Name How many yes How many No A peter 1 1 will 0 1 mark 1 0 B peter 0 1 will 1 0 mark 1 1 Total 4 4 What is the formula for this result.
These functionas are awesome! I definitely will be using them at work this week!
Glad you like them!
All Teachers tech videos have helped me understand excel better. It was so intimidating especially with formulas. Even though I still get confused with my work spreadsheets, I'm getting there day by day.
i just learned how to use countifs last second. just in time!! because of you. thanks
May God almighty continue to bless and enlarge your coast. You're a factory of excellence.
Jamie you make this so easy! Ive struggled with this in the past and now I get it perfectly clear. Thank you!
You are so welcome!
That cell reference with comparative operator is the key ..... great work!!
Thank you Thank you!!! This was very helpful for my project. It helped that you reviewed multiple methods and both SUMIF and SUMIFS. Exactly what I needed. 🤩
Oh my gosh your a life saver!!! God Bless you, ive been trying to figure this out for over 30 minutes
So well explained and very easy to follow. Thanks a million Jamie!
I really enjoy to learning Excel from your videos, its really helpful and nice explanation.
Thank you! This was explained so well and helped me get unstuck with something at work 😀
Your simplification is awesome
Great masterclass Sir Jamie Keet
Thank you this was helpful
OMG so glad to have found this video
Thank you for these videos. Subscribed.
great explanation! thank you
Very helpful, I was wondering if you could make a short video on how to take a block of cells , that are not a header or footer and freeze them to move with the page up and down. If you could that would be great thank you.
Thank you for this great video.
very helpful
Another great job on this video, Jamie. Thanks.
I am having an issue with getting circular reference errors. Maybe I am not coding the correct formula? I am new to using Excel (less than a month). Can you please do a video on this? I am taking 2 columns and subtracting a 3rd and placing the results in another column. Call them A+B-G results in column M. Now, I need to use the results in M and multiply that by column O which is a percentage and place those results in column B. Is this possible? Is that the problem? When I copy the formula down in B, I get a blue arrow connecting columns on other rows with the error dialog box popping up saying I have a circular reference. Am I not allowed to use the results of one calculation to create another calculation? Is it trying to do the multiplication before the addition so that the value in M is non-existent? Must I have these columns adjacent to each other or can they be spread out over the sheet as they are? I have been working on this for days, am I making sense? Please help? Thanks.
Beautiful
nice tutorial, thank you sir
You are welcome
Can I call myself " advanced in Excel" after watching and understanding your videos ?
THANK YOU
Thank you!
for the countifs, what if column E were dates and you wanted to see how many people earned over $2000 but only between a certain date range?
There are so so many excel videos. What do you advise to take to learn excel from basic to advanced
Nice video
Love it!
Realy Nice
Thanks!
really nice.
Can “countif wildcards” be applied for data across multiple worksheets? For example, I want to determine how many times a name appears in a current worksheet and all other previous worksheets.
Hi Jamie, thanks for this, it was inspiring to say the least! I was wondering if you could help (this maybe down to my own understanding or lack of it, rather than your clip). I am working on a spreadsheet and I need to find a formula that demonstrates if a number greater than 0 appears in more than 1 cell, for example in a football game, Team A V Team B, the final result is 2-1 and so Team A have won. What I need to identify is if that both teams have scored then the formula would display a result as YES or NO, or 1 or 0. Can you help?
You said you dropped the practice file link so we can download and follow along in this lesson. I couldn’t find it anywhere here in the description below
Let me check
Practice sheet: leveragingdigitalinc-my.sharepoint.com/:x:/g/personal/jamie_leveragingdigital_com/ERb6QtZDTfpLn11fzdmex6cBORS5L2IyljE9CviTaA259Q?e=rdkeUv
@@TeachersTech thank you very much
Chidi why can't you shoot your shot directly 😅, always going thru corners. I like that your improving in your acting, keep it up
Question
I have a drop-down menu in my spreadsheet
I used the Countif Function to count the total of the item
now I am trying to Subtract from that item when drop down is listed as deployed
Example =COUNTIF('Inventory List'!E5:E209,"p135g")-COUNTIF('Inventory List'!B5:B360,"deployed")
Keep Getting 0
I'm trying to get a simple COUNTIFS formula to work where if G3 is greater than 59 and G4 is "Over" it counts 1, BUT I need to do that for multiple sets(ie.G6 is greater than 59 and G7 is "Over"...G9 is greater than 59 and G10 is "Over"...etc. and give me a count for all of those instances. I tried the following but it counts "0" (=COUNTIFS(G3:G56,">59",G3:G56,"Over").
DOES ANYONE KNOW....How do we count the number of cells in a range that have a hyperlink that was entered via the 'insert link', and that also have text displayed in the cell? The link isn't in the cell display, which is how all your examples work.
Progress 😄
Head Name Count
A peter yes
A will no
B peter no
B will yes
A mark yes
B mark yes
A peter no
B mark no
This above said details are my Data.
But i want following type of results.
Head Name How many yes How many No
A peter 1 1
will 0 1
mark 1 0
B peter 0 1
will 1 0
mark 1 1
Total 4 4
What is the formula for this result.
thank you so much
your videos helped me alot
This is so helpful, thanks.