Create Interactive Worksheets in Excel by Using the IF and COUNTIF Functions

[@RRSSWanderWomanPh]

I watched your videos of pivot tables, vlook up, index & match and IF. All were in excellent explanation. Thank you so much!

[@deebaxley7800]

I *always* learn something new in Excel from your videos. In this case it was the "or"... love it. Thank you.

[@arunsanjeev5016]

Your videos are just simple, effective , well explained and powerful.I keep on watching your videos.Thank you so much sir.

[@jjessica7582]

Exactly what I m going to say

[@Hopefully2025]

This is really good stuff! Would there be a way for the default to be blank instead of the default being wrong?

[@lauraaquilano4954]

Thank you so much for being so clear!

[@azizamuhali5531]

Wawooo wawoooo very helpful, I was looking for the Count if function

[@adeltarakan7978]

That’s really very helpful

[@simoiyahector-morales3781]

👌🆒️ really helpful. Love your channel and all your tutorials. Simple and always effective

[@159357982]

your videos are very helpful .....thanks....the countif function is returning zero in the excel sheet provided..do you know why ?

[@azizamuhali5531]

Wonderful! If Excel recognize animals too to the extent it says if its a cat or a dog 😮

[@wasafisafi612]

thank you so much for the video

[@deopatel4453]

Never used thus function, thanks

[@xiaoluliu8001]

thank you so much.!

[@UdayKumar-gi9bs]

Good explanation thanks for your video... I have a doubt that how can we auto capitalize the first letter in words while typing in excel sheet..

[@gangpan2365]

Thanks! I learn from you a lot. Noticed that your avatar's lips are synchronized to the words you're speaking. How did you do that? Can you do a video about that? Thanks always!

[@markpodesta4605]

Thank you.

[@thaesu2121]

What should I do if the margin on the excel sheet is correct and the right margin is wider when printing with an epson printer?

[@ExtremeWays4Bourne]

Awesome. But could you advise how to deliver this to students? I mean they are not often used to Excel...

[@julztv9451]

sir please make a tutorial about precedence diagram method (PDM) using excel 🙏🙏🙏🙏 , im one of your followers ,when it comes to excel works ,you are my saviour.

[@mrmusicloverable]

What if the student clicks on the cells in column C and see the answer within the formula?

[@techteachersandstudents]

Great question. To prevent that, you can set the range B2:B8 to be editable when sheet is protected, and then simply protect the sheet. The students won't be able to see the formulas, and will only be able to type in cells B2:B8. I have a video that shows one way to do this: kzbin.info/www/bejne/ppqsiIemaNahmdk I'm also planning to make a new video soon which will show a simpler way to protect a sheet while still allowing parts of it to be edited. Thanks for watching!

[@amadogomez436]

How to create a invoice

[@praneetbag]

just download it

[@sladjanakalic385]

How to hide formula that students can not see the correct answer?

[@techteachersandstudents]

Great question. To prevent that, you can set the range B2:B8 to be editable when sheet is protected, and then simply protect the sheet. The students won't be able to see the formulas, and will only be able to type in cells B2:B8. I have a video that shows one way to do this: kzbin.info/www/bejne/ppqsiIemaNahmdk I'm also planning to make a new video soon which will show a simpler way to protect a sheet while still allowing parts of it to be edited. Thanks for watching!

[@sladjanakalic385]

@@techteachersandstudents Thank you so much for help and quick answer. The second video is also amazing.