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.