Thứ Hai, 11 tháng 9, 2017

Youtube daily report Sep 11 2017

Subscribe to our channel for more : http://bit.ly/2lB6QeW Visit our website : http://newzmagazine.com/

Couple Lose 2 Sons In Accident.

2 Years Later, Doctors Gasp Upon Discovery Inside Mom's Belly

Hadly and Gentry Eddings have unfortunately experienced tremendous loss in their young

lives.

A North Carolina pastor, Gentry has prayed endlessly for others in need of his support

and the blessings of their Lord.

But two years ago, people around the world were instead praying for him and Hadly.

In 2015, the blissfully in love couple were driving home from a family wedding Memorial

Day Weekend when tragedy struck.

Gentry had presided over his sister's beachside wedding and the family was traveling toward

home.

Hadley was pregnant with Reed and their two-year-old son Dobbs was in his car seat.

But their comfortable cruise home was horrifically interrupted.

Their vehicle was rear-ended by a truck driver.

At 37 weeks' pregnant, Hadly underwent an emergency cesarean section, but baby Reed

did not survive.

Dobbs perished in the accident.

The driver, Matthew Deans, received a shockingly short sentence of only 27 to 32 months in

prison.

Their church family from Forest Hill Church in Ballantyne and others across the country

mourned the young family's loss and prayed fervently for them at their time of such deep

grief.

It took awhile to recover from those dark days following the heartbreaking loss of their

sons.

The couple showed their true faith by publicly forgiving the driver.

But now, a light shines brightly upon the couple again.

God has blessed Hadley and Gentry with the birth of twin sons.

The beautiful boys were named in honor of their big brothers, Isaiah Dobbs and Amos

Reed, Hadley said.

"The Lord has not left us for one second in our grief of losing our two boys almost two

years ago.

God is a redeemer and a restorer!

God blesses us beyond what we deserve or could ever imagine ... We're rejoicing, and thank

Jesus for these two precious little ones!"

While Hadly and Gentry will never forget their sweet sons Reed and Dobbs, they are thrilled

to be parents once again.

Family friend Stacey Martin said that with the birth of the boys, "God is creating beauty

from ashes."

The couple encourages people to donate to Mission of Hope Haiti, an organization they've

worked with in the past, to help keep the legacy of their sons Dobbs and Reed alive.

For more infomation >> Couple Lose 2 Sons In Accident. 2 Years Later, Doctors Gasp Upon Discovery Inside Mom's Belly - Duration: 2:33.

-------------------------------------------

Как правильно продавать квартиры студии? Отзыв партнеров ЧипХоум. - Duration: 11:23.

For more infomation >> Как правильно продавать квартиры студии? Отзыв партнеров ЧипХоум. - Duration: 11:23.

-------------------------------------------

Vikram Vedha Vijay Sethupathi intro surrendering Movie Scene HD - Duration: 2:34.

Can I tell you a story sir?

The silence is too deafening, huh?

You look really smart when you smile sir

But you will look very pathetic if you smile without your front teeth!

Don't laugh.

Camera is switched off...

I'll smash you!

Just my arm will swell up a bit... nothing much!

Sir, will you treat your guest this way?

Vedha no violence sir!

Why did you surrender?

Just wanted to tell you a story sir

My own story sir!

Your kind of guys just have one story, right?

I was down and out...like a mongrel on the mean streets

Did this and that...and grew to be a big man

It's that story, right?

Wow!

How did you do it sir?

Did you watch my whole life unfurl in my own eyes?

Can I tell you something about yourself?

If I give you 10crores today in exchange for you quitting your profession...

you will refuse the offer and walk out

Only to go home and plot a way to grab the money from me!

That's you!

The same 10crores, if I give you in exchange for letting me go...Will you let me go sir?

You will just send me away and plot to encounter me!

That's you, right?

Hah, good one!

However you see it, we are both one and the same!

How will having just a tail make a cat and mouse the same?

Sir, the cat has value only till there's rat problem in the house!

But this mouse surrendered fearing the cat, right?

But, will any mouse voluntarily walk into a trap?

That's right.

We're not talking about some simple mouse here...

It's actually a bandicoot who has murdered 16!

You are not such a simple cat yourself sir...

A cop cat who has encountered 15!

18

Sir, that last encounter... you killed the guys?

OK sir.

You are in the lead

Killed 18; Killed 16...Convinced?

Nah...

Criminal!

Police...

I'm on the right side of line; you on the other

OK sir, I accept.

I'm the bad guy; you're the good one

But to project yourself as a good man, you do need a bad man like me!

Now listen to the bad man's story; it will be

interesting, enthralling with twists and turns!

Listen!

For more infomation >> Vikram Vedha Vijay Sethupathi intro surrendering Movie Scene HD - Duration: 2:34.

-------------------------------------------

Volvo Penta Boating Dreams – Trailer - Duration: 0:37.

For more infomation >> Volvo Penta Boating Dreams – Trailer - Duration: 0:37.

-------------------------------------------

The Art of Deflection - Duration: 43:05.

For more infomation >> The Art of Deflection - Duration: 43:05.

-------------------------------------------

The Wrong Man - Duration: 42:34.

For more infomation >> The Wrong Man - Duration: 42:34.

-------------------------------------------

The Queen Mary - Long Beach, California (2017) - Duration: 1:21.

[music]

>> You are invited to step back in time

stay aboard in a unique Art Deco stateroom.

Shop and discover hidden treasures at sea

explore a world where imagination has no limits

walk through time

touch history

indulge in award-winning dining and

spectacular ocean views

immerse yourself and awaken your senses

to the spirit of elegance, class, and style.

Start your journey today. Live royally Queen Mary

Get the Queen Mary SoCal

pass today for just $29.

you

For more infomation >> The Queen Mary - Long Beach, California (2017) - Duration: 1:21.

-------------------------------------------

Wat is Influencer marketing? - Duration: 1:29.

For more infomation >> Wat is Influencer marketing? - Duration: 1:29.

-------------------------------------------

HSN | SERENA WILLIAMS Signature Statement Fashions 09.11.2017 - 12 AM - Duration: 1:00:01.

For more infomation >> HSN | SERENA WILLIAMS Signature Statement Fashions 09.11.2017 - 12 AM - Duration: 1:00:01.

-------------------------------------------

Rainbow Wheels on the Bus | Kindergarten Nursery Rhyme Song for Kids by Little Treehouse - Duration: 2:11.

The wheels on the bus go round and round

Round and round, round and round

The wheels on the bus go round and round

All through the town

The wipers on the bus go swish, swish, swish

swish, swish, swish, swish, swish, swish

The wipers on the bus go swish, swish, swish

All through the town

The horn on the bus goes beep, beep, beep

beep, beep, beep, beep, beep, beep

The horn on the bus goes beep, beep, beep

All through the town

The windows on the bus go up and down

Up and down, Up and down

The windows on the bus go up and down

All through the town

The seat on the bus goes squeak, squeak, squeak

squeak, squeak, squeak, squeak, squeak, squeak

The seat on the bus goes squeak, squeak, squeak

All through the town

The monkey on the bus goes giggle, giggle, giggle

giggle, giggle, giggle, giggle, giggle, giggle

The monkey on the bus goes giggle, giggle, giggle

All through the town

The wheels on the bus go round and round

Round and round, round and round

The wheels on the bus go round and round

All through the town

For more infomation >> Rainbow Wheels on the Bus | Kindergarten Nursery Rhyme Song for Kids by Little Treehouse - Duration: 2:11.

-------------------------------------------

New Best Method Download Music & Videos Free iOS 9 to 11 No Jailbreak No Revoke - Duration: 2:27.

Subscribe Our Channel

For more infomation >> New Best Method Download Music & Videos Free iOS 9 to 11 No Jailbreak No Revoke - Duration: 2:27.

-------------------------------------------

Altertale crossover - "Once Upon a December" - Duration: 2:43.

Silver blades

Painted wings

Things I know are of import

And a song

Someone sings

Kansas lyrics known by heart

Carry on my wayward son

There'll be peace when you are done

Brothers fighting gracefully

Across my memory

Someone holds me safe and warm

An overcoat and freckled arms

Things I've done so sickening

Across my memory

Far away, long ago

Things I know are of import

And a song someone sings

Zeppelin lyrics known by heart

And a song someone sings

Classic lyrics known by heart

For more infomation >> Altertale crossover - "Once Upon a December" - Duration: 2:43.

-------------------------------------------

Dinosaur Fighting Action Movie For Kids 3D King Kong Dinosaurs Cartoons For Children Dinosaur Attack - Duration: 11:16.

Dinosaur Fighting Action Movie For Kids 3D King Kong Dinosaurs Cartoons For Children Dinosaur Attack

For more infomation >> Dinosaur Fighting Action Movie For Kids 3D King Kong Dinosaurs Cartoons For Children Dinosaur Attack - Duration: 11:16.

-------------------------------------------

Top 10 Famous Stylish / Fashionable Mother and Daughter Jodis Of Bollywood ! 2017 - Duration: 4:03.

Top 10 Famous Stylish / Fashionable Mother and Daughter Jodis Of Bollywood ! 2017

For more infomation >> Top 10 Famous Stylish / Fashionable Mother and Daughter Jodis Of Bollywood ! 2017 - Duration: 4:03.

-------------------------------------------

11/09/2017 08:20 (Pine Cottage, 9 Brockenhurst Rd, Ascot SL5 9DJ, UK) - Duration: 2:59.

For more infomation >> 11/09/2017 08:20 (Pine Cottage, 9 Brockenhurst Rd, Ascot SL5 9DJ, UK) - Duration: 2:59.

-------------------------------------------

MARGUERITE ET LA BÊTE FÉROCE - La petite ville des artifices - Duration: 23:52.

For more infomation >> MARGUERITE ET LA BÊTE FÉROCE - La petite ville des artifices - Duration: 23:52.

-------------------------------------------

Ford Fiesta 1.25-16V Centennial - Duration: 0:58.

For more infomation >> Ford Fiesta 1.25-16V Centennial - Duration: 0:58.

-------------------------------------------

GALATASARAY | 11 EYLÜL 2017 | SABAH SPORU GS GÜNDEMİ TEK PARÇA | ÇİĞDEM CEYLAN | Youtube - Duration: 19:38.

For more infomation >> GALATASARAY | 11 EYLÜL 2017 | SABAH SPORU GS GÜNDEMİ TEK PARÇA | ÇİĞDEM CEYLAN | Youtube - Duration: 19:38.

-------------------------------------------

[Free] xxxtentacion Type Beat

For more infomation >> [Free] xxxtentacion Type Beat

-------------------------------------------

DAHAB COLLECTION | Top Beautiful Designer Kurta/Kurti Designs 2017-2018 | New Fashion Trand - Duration: 2:37.

DAHAB COLLECTION | Top Beautiful Designer Kurta/Kurti Designs 2017-2018 | New Fashion Trand

DAHAB COLLECTION | Top Beautiful Designer Kurta/Kurti Designs 2017-2018 | New Fashion Trand

Welcome to the hab collection subscribe to our channel by clicking the subscribe button

Click the bell button and enjoy the latest uploads from our channel

You

For more infomation >> DAHAB COLLECTION | Top Beautiful Designer Kurta/Kurti Designs 2017-2018 | New Fashion Trand - Duration: 2:37.

-------------------------------------------

NIBIRU SHOCK 72 HOUR WARNING DEEP IMPACT ASTEROID DUE TO ROCK THE WORLD 11st September 2017 - Duration: 48:33.

For more infomation >> NIBIRU SHOCK 72 HOUR WARNING DEEP IMPACT ASTEROID DUE TO ROCK THE WORLD 11st September 2017 - Duration: 48:33.

-------------------------------------------

Johny Johny Yes Papa

For more infomation >> Johny Johny Yes Papa

-------------------------------------------

For more infomation >> Johny Johny Yes Papa

-------------------------------------------

Cómo cambiar copelas del amortiguador TOYOTA YARIS XP10 INSTRUCCIÓN | AUTODOC - Duration: 10:24.

Use a socket №14

Use a socket №19 and a combination spanner №19

Use a combination spanner №12

Using a special tool to compress the spring

Use a socket №17

For more infomation >> Cómo cambiar copelas del amortiguador TOYOTA YARIS XP10 INSTRUCCIÓN | AUTODOC - Duration: 10:24.

-------------------------------------------

For more infomation >> Cómo cambiar copelas del amortiguador TOYOTA YARIS XP10 INSTRUCCIÓN | AUTODOC - Duration: 10:24.

-------------------------------------------

Destiny 2: Live Action

For more infomation >> Destiny 2: Live Action

-------------------------------------------

M-Budget: Let's go blindshopping! | MIGROS - Duration: 1:13.

For more infomation >> M-Budget: Let's go blindshopping! | MIGROS - Duration: 1:13.

-------------------------------------------

Kolkatar Rasogolla-Full video | Cockpit | Dev| Koel | Rukmini | Evergreen-Remix song| Kamaleswar M - Duration: 2:24.

For more infomation >> Kolkatar Rasogolla-Full video | Cockpit | Dev| Koel | Rukmini | Evergreen-Remix song| Kamaleswar M - Duration: 2:24.

-------------------------------------------

【Logless】 Collaboration medal I only have it introduced - Duration: 11:14.

For more infomation >> 【Logless】 Collaboration medal I only have it introduced - Duration: 11:14.

-------------------------------------------

Rick and Morty - Hurt - Duration: 2:16.

Hello, this is

Stinky Pete

And I'm going to do a rendition

Of the song originally by Trent Reznor

Famously covered by Johnny Cash

I hurt myself today

To see if I still feel

I focus on the pain

The only thing that's real

The needle [???] a hole

The old familiar sting

Itrytokillit all away

But I remember everything

Auuuuughwhat have I beco *coughs*

My sweetest friend

Everyone I know goes away

In the end.

For more infomation >> Rick and Morty - Hurt - Duration: 2:16.

-------------------------------------------

New Danganronpa V3: True Ending Part 4 (Final Part) English Subtitles (Turn On Captions) - Duration: 24:28.

Hey ... what happened?

... Kiibo?

I already told you ... it's pointless

It's obvious ... the outside world does not want Danganronpa to end.

Everyone ... loves Danganronpa ...

That's reality! The killing game entertainment will go on forever!

Well then, the voting time will start soon.

Upupu ... Kiibo-Kun who believes in hope, will obviously vote for Shirogane-San

Because, that is what the outside world wants!

Well, let's begin! The final voting time!

Well, it seems like the voting is over, let's announce the results right away.

I ... I abandoned the vote. Did I make the right choice?

The three of us who abandoned the vote will definitely be killed due to the penalty ...

But what about Kiibo and Shirogane?

Kiibo is being controlled by the outside world, Hopefully Shirogane only got one vote ...

But what about Shirogane?

If both Kiibo and Shirogane voted, then each of them would only have one vote.

Oh, You don't need to worry about that. I also abandoned the vote.

... Huh?

So you ... were going to let hope win the vote.

Well we're all friends ... aren't we? I can't just let you abandon your vote alone.

You aren't our friend! What are you talking about!

Upupu ... i've been reformed. I'm telling the truth. I'm not lying.

So ... the fact that all four of us abandoned the vote means that only Kiibo-Kun will have a valid vote.

No matter what he voted for, he will be the only one who will survive.

In other words, hope will win once again.

But didn't you all Kiibo-Kun agree little while ago? He would sacrifice his life and be executed ...

Well then, I will punish Kiibo-Kun. I will make him participate in the next killing game.

Hold on! Why is Kiibo being punished?

If Kiibo is the only survivor, his sacrifice becomes pointless

I have to do this. I have to do what I promised to do.

You are such a coward! You're just going to change the rules again!?

It's fine, this is just fiction after all.

This is a forced development ... but that's just how fiction is right?

Well, because I abandoned the vote, I will also be killed due to the penalty ...

I am also sacrificing my life.

If everyone is willing to sacrifice their lives to end this killing game, then I will sacrifice mine to continue it.

This may all just be fiction, but I am willing to sacrifice my life for it.

... I am sacrificing my life for Danganronpa

Well ... this scenario is fine.

At the end of the long battle, hope won the fight, but the surviving Kiibo-Kun fell right into the mastermind's trap.

He will participate in another killing game. That's where he will find ... true hope!

... well, isn't that a fine ending?

... How? This is horrible

This can't ... happen. If things go this way, everyone's sacrifice will be pointless ...!

Well, the vote is already over, so everything has already been decided ...

Monokuma ... can you tell us the results?

Yes! It's finally time!

It's time to find out, who is the blackened!? Will hope or despair win!?

Results

No votes

Class Trial End

... Huh?

All five people ... didn't vote?

What's going on!? Kiibo-Kun didn't vote!?

Ha ... i'm so glad.

What's going on ...? Why? Why is this happening?

... the world changed.

Huh?

The fact that there was no vote proves that.

Even the people controlling Kiibo-Kun, denied the vote.

... they denied this killing game

W - what ...!

Have you realized it yet? It's because you violated the rules!

Wait ... a minute! Is this really fine!?

Danganronpa is over?

The killing game full of suspicion ... the betrayal of friends ...

The series is finally completed after 53 installments ... is it really okay for it to end this way!?

...Huh?

The outside world is no longer listening to you.

The feelings, deaths and our thoughts, that you took so lightly should not be taken lightly in a fictional world!

No one wants to see the fiction that you make!

It's over ...

it's the end ...

It's the finale ...

It ... really is the end.

What's going to happen now?

Now that this series is over, I don't think there is any reason to give us the penalty ...

We won't be half-assed about this. It will end properly, just like Danganronpa should.

Just like it should ... at least.

Yeah, I ... though so.

Besides ... if we live here, the choice that we made earlier won't be taken as seriously.

Then, someone may want another killing game someday ...

We can only end this killing game by sacrificing our lives.

Okay, I understand! I won't be hungry when this is done!

Everyone ... is going to die together

I never predicted an ending like this, I haven't prepared an appropriate execution for us ...

So, i'll let Kiibo-Kun do it.

... all right I understand, i'll do it.

I will use my own two hands to end this killing game.

I will end this fiction.

This is ... the desire of the outside world

I will destroy this fictional world, and end this killing game ...

That's ... what the outside world wants.

Even though I made it all the way ... to 53 installments ... everything is going to end right here.

Well, that's fine ... even in fiction you can't enjoy the killing game ...

... I will deny this.

I don't want to live in a world, without Danganronpa

On top of that ... this is far from a happy ending.

No survivors left ... Just looking at the results is saddening.

But, this is the end of it all. We will be the last ones to suffer in these killing games ...

... We can be proud of this. We were the ones who changed the world.

If this world is just fiction, what we have learned may all just be a lie.

But, we can change the world with that lie.

Even though we are just fiction, just created from someone's imagination ...

We .can change the world

That's right ... I feel the same way.

My plan failing at the final moment made my "imitation" perfect ...

I can be proud of myself as a "imitator" (cosplayer) right?

... imitator?

... Well, let's begin

Now, Let's end it! This is the desire of the outside world!

Shirogane-San, Saihara-Kun, Yumeno-San, I will begin the execution now.

I will start to destroy this school.

Item received! Danganronpa 53!

You have received a new theme "Danganronpa 53"

Item received! Team Danganronpa Employee medal!

Item received! Variety cushion!

Item received! Color roulette!

Item received! Easter egg!

In order to use the perks for finishing the game you have to save first.

We highly recommend that you save the game.

Are you okay ...?

... Yeah, somehow.

I - i'm in a bit of a pinch here ...! Can ... someone please help me out ...!?

Yumeno-San ... hold on

Ah ... thanks, you saved me ...

We're alive.

Hey, why are we alive? Why are we, still alive?

I wonder ... why are we still alive?

Yeah ... I wonder why ...

The killing game is over ...

The class trials are over ...

The fictional world ... is over

So, where are we?

Now that the fictional world has ended ...

What will remain of it?

Everyone's Killing Game Graduation

We stayed silent for a while and we just looked toward the outside.

We kept wishing ...

We kept suffering ...

"The outside world"

For 53 times people were wishing and suffering ...

On the other side of this fiction is the real world.

... But, what are we going to do now?

Well ... I didn't really think about that. I thought everything would be over.

But, we are still alive

That isn't a lie ... that is definitely the truth.

In that case, we have to go outside. We can't stay here any longer.

But ... I still don't get it. Why are we still alive?

When I saw this world being destroyed, I though that we were going to be destroyed with it ...

Maybe Kiibo saved us ...

He made it so we wouldn't have to die.

For what reason ... would he do that?

We are just fiction, even if we get into the outside world there is no point to it ...

Also ... wasn't he supposed to acting on "the will of the outside world"?

Well ... what was the will of the outside world?

Huh? Did they want us to survive?

The "outside world" accepts the end of the fictional world, but they still wanted us to survive ...

In other words, the "outside world" wanted this lie to become the truth.

If so, we should be able to go into the outside world as ourselves.

Beyond there ... is the outside world.

What is ... the outside world like?

A peaceful world without despair or fighting, Just peace. That's what Shirogane said ...

At least ... if that wasn't a lie.

What!? Are you saying that it might be a lie!?

Think about ... the last thing that Shirogane-San told us.

My plan failing at the final moment made my "imitation" perfect ...

I can be proud of myself as a "imitator" (cosplayer) right?

She called herself an "imitator"

So doesn't that mean ... that she was just "imitating" somebody else?

What do you mean?

... What do I mean?

What! You don't know!?

But ... there are still alot of questions that need to be answered. for example ...

Weather or not "Hope's Peak Academy" or "The Remnants of Despair" actually exist ...

Shirogane-San may have been imitating, Junko Enoshima's killing game.

Are you saying that this world being fiction, is just Shirogane's lie?

What!? We're going back!?

Well, I can't be sure of the truth ... what she said about being an "imitator" might also be a lie.

If what she said was true, I might be able to accept her lie about "that"

What's "that"?

What Shirogane-San told us ... when we first arrived at this academy.

Huh? What ...? What's up ... with these clothes ...?

You look just like a "Super High School" Level student.

... A "Super High School Level" student?

Well then ... time to give you those memories.

Hell Yeah! You better be ready! You will enter the killing game after this!

... killing game?

Am I ... seriously being chosen!?

Well then, does that mean we were accepted!? That's what that means right!?

Are you serious!? We're going to participate in "that"!?

I just ... can't believe that we would willingly enter a killing game.

Well, it's all just because of the "remembering light", that's what caused us to forget right?

Yeah, That's what Shirogane-San said ... but there is something odd going on.

No matter how bad the world I was living in was, I don't think I would have joined something like this.

I just ... can't believe it no matter what.

Well ... it's not like I have a way to prove it.

Is it the intuition ... of Momota-Kun?

Even so, isn't it true that we don't have a way to prove what happened the first time we came to this academy?

Yeah ... that's right ...

I guess, we really have no way of being sure.

We ... really can't tell what's a lie, and what's the truth even after making it this far ...

It looks like this is the end for this world, the only place we can go is that world on the other side ...

If that's the case, I thought I would be able to find the truth over there ...

... But that might not be the case

It's possible, that the fiction might continue on the other side as well ...

Maybe the world of Danganronpa will continue ...

The outside world ... might be the same as the world in here.

A world ... with even more lies.

Well, we''ll know for certain once we leave this place.

But, I don't think that what's the truth and what's a lie, really matters anymore ...

... Huh? What do you mean?

Because even if it's a lie ... even if it's fiction ...

We have the power to change the world, and I think that's the same as the truth.

Because, that's exactly what we are right?

In this fictional world we've gone through many crazy events ...

All those events changed us ... and in the end, we were able to change the world ...

So if it's a truth or a lie doesn't matter. If it's fiction or reality doesn't matter.

If truths are capable of changing the world, lies are also capable of doing the same ...

Isn't a lie ... just a truth with a different form?

If a lie, is capable of leading the world into hope, then the truth could lead the world into despair ...

Does anyone actually know if a truth or a lie is the correct choice?

The question isn't weather a lie or the truth is the correct answer, this question is what you take from them ...

Yes, That is what I think.

Now that we are standing right here between fiction and reality, I might think that way ...

Well then ... we need to know for certain. We need to know how the outside world was changed by fiction ...

And us, who have overcome all this suffering, have to see what we can do out there ...

That's right ... the world doesn't need a fiction that has already ended.

I think, I should bring all the emotions that I had in this world, into the next world.

That's right ... let's go out there together.

With everything we've gained in this world and everything we've lost in it ... together

Let's go make sure of it.

The other side of this world ...

The other side of fiction ...

Let's go make sure of it

... What we have done here.

... This story will continue.

Even, on the other side ...

It will even continue on the other side of fiction ...

That's how ... the story will continue.

What did this lie change?

Did this lie change someone?

Did this lie change the world?

Even if it only changed something a little bit ...

... This is not the end of the story.

For more infomation >> New Danganronpa V3: True Ending Part 4 (Final Part) English Subtitles (Turn On Captions) - Duration: 24:28.

-------------------------------------------

Basic Excel Functions: SUM, COUNT and AVERAGE - Duration: 7:09.

Welcome to the first episode of Excel for Everyone

I'm Mohamed Nada, and today I'll talking with you about some basic functions

in Excel, and they are actually some of the most important functions in Excel

that no one can be using Excel without learning those functions first.

It's like when you first go to school and you learn how to add and subtract

Those functions are: SUM, COUNT and AVERAGE

SUM is simply you add

a range of cells

COUNT is that you count this range, and AVERAGE

is you get the average of this range. And we will see

their IFs. Which are SUMIF, COUNTIF and AVERAGEIF

Which is that you SUM, COUNT or get the AVERAGE of

a range of cells on a specific criteria that

you choose

Let's see how it works

We have an Excel table that contains City names

, the population for each City and the country of each city

And we would like to calculate these metrics.

Some of them are straight forward

and some are a bit tricky, like

getting the sum of population in English cities only.

Now let's start with the first one: Sum of population in all cities

Go to the formula bar and put an = sign

type sum and open bracket. Then select

the range that we would like to add and then close the bracket and hit Enter

There is another way

to get the same result where you type sum, open bracket

and choose the whole column instead of choosing exactly the range

you get the same result but why this method is useful?

if at any point in time you update the table by adding a new row,

the formula is calculated automatically

which means you don't have to update the formula every time you add a new row to the table

COUNT works the same way. Type an = sign

then count

and choose the population range

you might ask why I've chosen the population

and not the city. The reason is that COUNT

works with numerical values only

it doesn't work on Text

If you try to change to the city column

you'll get a zero

what if I want to count text?

I use another function called COUNTA

So if we retry with COUNTA

and choose the cities column, I will find the actual count

but beware, Excel counted 20

while they are actually 19

so why the result was 20?

because Excel included the header, and the header is text

But if you used COUNT with population column

the result is 20

because Excel took only the numbers, and excluded the header

because it's Text.

Now let's look at SUMIF

If I need to look at the sum of population in English Cities only

Go to the formula bar, = sign,

SUMIF and choose the range, but before we do it, let's

look what do I want Excel to actually do

I want Excel to

look at the first row, if it's England,

take it's population, then move on to the next row

until he finds Scotland, which is not in my criteria

so I want Excel to ignore Scotland and move on

and so on

so Excel does this using SUMIF

so the first thing is type the function and then choose the range

the range is what includes my criteria

in this case it's the country column

then type the criteria which is England in our case

and note the speech marks " " before and after typing England

this is because my criteria is Text. If my criteria is a number

I would write the number normally without speech marks

then I put the sum range.

The range here is the population column. This is what I want the sum for

then close bracket. I got 13 million

Let's make sure this formula works properly

if I select the population manually for England only

I will get the same result. So my formula is correct.

Now Count of cities in England. The same approach

Type in the formula bar COUNTIF

and choose the range

the range that includes England

the result is 15. Note that in COUNT

there is no Countrange like Sumrange because I already gave the order

to Excel to Count, so he counted the cells and got the result

Average works the same way as SUM and COUNT

just choose the range for your Average

close the bracket

AVERAGEIF works the same as SUMIF

choose the range that includes your criteria

then England and then choose the population

as the average range and close bracket

and this would be the average for the English cities only

And that was the last thing for today

thanks and see you next time. Bye!

Không có nhận xét nào:

Đăng nhận xét