Mr Excel & excelisfun Trick 13: AVERAGE without Zeroes

[immune2pain]

Question ---->major questions (as in i havnt met a person who can solve it) basically i understand how to do the equation if my cell where all within a range however i have to select 6 seperate cells and trying to do it your way aswell as the other 1000 i have tried have all said too many arguements :/ any help would be epic !!!! cheers

[skullfacedarkness]

i have a question. have you got a video that shows you how to put one formula in, times tables that will then do the rest of the time table?

[ExcelIsFun]

Sure. Try this video:

Excel Basics #9: Mixed Cell References in Formulas

[ialghazali1]

thank very good

[ExcelIsFun]

You are welcome!

[johndavidligertwood]

Thanks so much for all your efforts You guys are awesome!!

John

[ExcelIsFun]

Cool! I am glad that you like the videos! They sure are fun to make!!

[gdtorrefiel]

Hello, you two are GREAT! How I wish, I am one of your classroom student! Your students are very lucky to have you. Keep up the good work.

[ExcelIsFun]

Dear gdtorrefiel,

We'll keep making videos! And you can come and be in my class anytime!!

--excelisfun

[blackhand1818]

thanks for making such an entertaiing and educative dual podcast. I still wish I can find a way to convert ALL numbers or a selected range into currence of choice not just EURO currencies

[ExcelIsFun]

Dear blackhand1818,

Did you try Number Formatting in Format Cells Dialog box? If you select Currency or Accounting there is an option for different currencies.

--excelisfun

[kelch12]

Excel-lent!! Keep up the good work and thanks!!

[ExcelIsFun]

Dear kelch12,

You are welcome!

--excelisfun

[INGc3z4r]

Great video!

[ExcelIsFun]

Dear INGc3z4r,

Thanks! Glad that you like it!

--excelisfun

[horsingaroundfla]

ExcelIsFun & Mr Excel is best thing on youtube.

[ExcelIsFun]

Dear horsingaroundfla,

Thanks! We'll keep making videos!

--excelisfun

[kami645464]

Really nice. I have seen this combination the first time so far. It seems to be working very well and is much more entertaining than the other videos (which I do not find boring, but just for some other watchers, who can't focus for that long).

Again: Great videos you are making!

[ExcelIsFun]

Dear kami645464,

I am glad that you like it!

--excelisfun