**Question description:**

*This user has given permission to use the problem statement for this blog.*

I need a formula that is essentially saying IF this range of cells contain a certain name, add the number in another cell on the same row, and them sum that number in a different cell..!

Solved by O. H. in 44 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

User
02/02/2018 - 06:02

Heya

User
02/02/2018 - 06:03

This is verryyy coool

Excelchat Expert
02/02/2018 - 06:03

hello thank you for choosing Gotit.

Excelchat Expert
02/02/2018 - 06:03

do you have the excel sheet so that i can fix the formula?

User
02/02/2018 - 06:03

I do but I can't share. Can I quickly do a version of it here?

Excelchat Expert
02/02/2018 - 06:03

It is cool. Welcome.

Excelchat Expert
02/02/2018 - 06:04

its fine

User
02/02/2018 - 06:06

So what I'm trying to do is make a sum in C4

User
02/02/2018 - 06:06

That is something like IF the cells in Sheet 2 range A4 : A8 say Sam Smith

User
02/02/2018 - 06:06

Add the numbers on the equivalent row between B4 : B8

User
02/02/2018 - 06:07

And sum it on sheet 1 C4

User
02/02/2018 - 06:07

if that makes sense...

Excelchat Expert
02/02/2018 - 06:07

yes it does. give me a moment

User
02/02/2018 - 06:07

niiiceee!

User
02/02/2018 - 06:15

You thinking it's possible to do? Or am I asking for something crazay?

Excelchat Expert
02/02/2018 - 06:18

it is possible. just hang on

User
02/02/2018 - 06:18

okay awesome thank you!

Excelchat Expert
02/02/2018 - 06:18

almost. Using IFS formula

User
02/02/2018 - 06:18

I wondered if it would be an IF or a SUMIF

Excelchat Expert
02/02/2018 - 06:30

sorry for the delay. you use sumif formula. let me upload a file for you that i have worked on

User
02/02/2018 - 06:30

okay coool thank you!

Excelchat Expert
02/02/2018 - 06:37

[Uploaded an Excel file]

Excelchat Expert
02/02/2018 - 06:37

see the formula above?

User
02/02/2018 - 06:37

Just downloading

Excelchat Expert
02/02/2018 - 06:38

check the one on google sheet while that download

User
02/02/2018 - 06:39

omg I don't even understand that

User
02/02/2018 - 06:40

So it's saying if A4 appears in this range, sum the number in this other range. Right?

Excelchat Expert
02/02/2018 - 06:42

look at this google sheet here. Sam smiths days are 15 based on the information on sheet two, right? all i do is to sum days based on the name here sam smith

User
02/02/2018 - 06:43

damn damn

User
02/02/2018 - 06:43

That's so smart. I thought I would have to reference Sam Smith somewhere in the sum but instead you reference the cell containing Sam Smith

User
02/02/2018 - 06:43

genious

User
02/02/2018 - 06:43

genius....*

Excelchat Expert
02/02/2018 - 06:43

now you get it

User
02/02/2018 - 06:44

very very cool. I just tried it in my spreadsheet too and it's worked.

User
02/02/2018 - 06:44

Thank you so much!!

Excelchat Expert
02/02/2018 - 06:44

cool. Is it working?

User
02/02/2018 - 06:44

Yeah perfectly!

User
02/02/2018 - 06:44

This is a very cool system. Didn't even know this existed

Excelchat Expert
02/02/2018 - 06:45

Wow. am glad i helped.

Excelchat Expert
02/02/2018 - 06:45

We are here to help. Give me a 5* rate at the end of this chat if you dont mind

User
02/02/2018 - 06:45

Definitely definitely will. Thanks so much!

User
02/02/2018 - 06:45

Have a good evening wherever you are in the world.

Excelchat Expert
02/02/2018 - 06:46

its Morning here. Good evening too!

User
02/02/2018 - 06:46

Thaanks!

User
02/02/2018 - 06:46

See ya!

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*