i just learned how to use countifs last second. just in time!! because of you. thanks

These functionas are awesome! I definitely will be using them at work this week!

That cell reference with comparative operator is the key ..... great work!!

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!

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.

May God almighty continue to bless and enlarge your coast. You're a factory of excellence.

Your simplification is awesome

Great masterclass Sir Jamie Keet

Jamie you make this so easy! Ive struggled with this in the past and now I get it perfectly clear. Thank you!

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. 🤩

OMG so glad to have found this video

Thank you! This was explained so well and helped me get unstuck with something at work 😀

I really enjoy to learning Excel from your videos, its really helpful and nice explanation.

Thank you for these videos. Subscribed.

THANK YOU

Thank you for this great video.

great explanation! thank you

This is so helpful, thanks.

thank you so much your videos helped me alot

Love it!

Thank you!

Nice video

Beautiful

really nice.

nice tutorial, thank you sir

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.

Realy Nice

Progress 😄

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?

Can I call myself " advanced in Excel" after watching and understanding your videos ?

There are so so many excel videos. What do you advise to take to learn excel from basic to advanced

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").

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

Once you have a count, how can you show what they are using the count?

Chidi why can't you shoot your shot directly 😅, always going thru corners. I like that your improving in your acting, keep it up

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.