All solutions SUM Expert Solution – Excel SUM Problems

Excel - SUM Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

i want to sum the unique data from a list then return the sums as subtotals and then sum the subtotals as a grand total
Solved by I. L. in 50 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 17/03/2018 - 01:04
Hi there
Excelchat Expert 17/03/2018 - 01:05
How are you and how may i assist you with today
User 17/03/2018 - 01:05
G'Day mate I'm Steve how area ya?
Excelchat Expert 17/03/2018 - 01:05
M good too, Steve
User 17/03/2018 - 01:06
whats ur name?
Excelchat Expert 17/03/2018 - 01:06
i'm Hamza
User 17/03/2018 - 01:06
ok so where are you from? and are you a male or female?
User 17/03/2018 - 01:07
I've never heard that name before
Excelchat Expert 17/03/2018 - 01:07
m from India and m a Male
User 17/03/2018 - 01:07
ok
Excelchat Expert 17/03/2018 - 01:08
So lets move towards the issue, Steve
User 17/03/2018 - 01:08
ok ill make an example in the sheet and we can discuss, i think it might be a simple issue
Excelchat Expert 17/03/2018 - 01:08
yep, that will be great!
Excelchat Expert 17/03/2018 - 01:13
i guess you should have prepared this earlier, session time is running out
User 17/03/2018 - 01:14
this is a start think you should kind of understand what I'm doing
Excelchat Expert 17/03/2018 - 01:15
Yes i can frame it some
Excelchat Expert 17/03/2018 - 01:15
So you want total time for each of the items in column B right?
User 17/03/2018 - 01:16
so i want to sum the times for each unique name then sum the subtotals a grand total
User 17/03/2018 - 01:16
yes
Excelchat Expert 17/03/2018 - 01:16
yep, sure will help you out with this
User 17/03/2018 - 01:16
oh now i should say
Excelchat Expert 17/03/2018 - 01:17
So for this we will be using Sumif formula
User 17/03/2018 - 01:17
column B has a formula in each cell that is returning the data that is currently there from somewhere else
Excelchat Expert 17/03/2018 - 01:17
Thats fine, it wont impact
User 17/03/2018 - 01:18
ok i get the idea of sumif
Excelchat Expert 17/03/2018 - 01:18
i have done it shall i share you the sheet?
User 17/03/2018 - 01:18
i just don't know the syntax or the kind of code to write to do that kind of formula
User 17/03/2018 - 01:18
yes
Excelchat Expert 17/03/2018 - 01:19
Please review and let me know
[Uploaded an Excel file]
User 17/03/2018 - 01:21
ok just looking I'm just trying to understand the summit you wrote give me a second
Excelchat Expert 17/03/2018 - 01:21
Yea sure
User 17/03/2018 - 01:22
ok thats great i understand completely
User 17/03/2018 - 01:22
it works great and is quite simple
Excelchat Expert 17/03/2018 - 01:22
please do a valuable rating , Steve
User 17/03/2018 - 01:22
sure will but i have some more questions if you don't mind
Excelchat Expert 17/03/2018 - 01:23
Well we are allowed to support 1 question per session, as per got it pro! policy
Excelchat Expert 17/03/2018 - 01:23
still verbally i can help you out
Excelchat Expert 17/03/2018 - 01:23
please go ahead
User 17/03/2018 - 01:24
oh i didn't know because i just extended my session time for more questions
User 17/03/2018 - 01:24
ok well this is part of a workbook and there are other things I'm doing
Excelchat Expert 17/03/2018 - 01:24
Thats okay
Excelchat Expert 17/03/2018 - 01:24
okay
User 17/03/2018 - 01:24
well its not ok for me if i can't get any more help
Excelchat Expert 17/03/2018 - 01:25
okay you may share the workbook so we can discuss verbally on that
User 17/03/2018 - 01:25
maybe i need to log in again and ask my 1 question as a 16 part question so i can get more questions answered within my 1 question
User 17/03/2018 - 01:26
well i can't share the workbook as its classified
Excelchat Expert 17/03/2018 - 01:26
Okay please go ahead with your question
User 17/03/2018 - 01:26
unless you have an Australian, British or American clearance level of G14 or above you can not look at this workbook
User 17/03/2018 - 01:27
it is classified as "Eyes Only"
Excelchat Expert 17/03/2018 - 01:27
Okay
User 17/03/2018 - 01:27
but i can talk about different examples to similar problems as i have so far
Excelchat Expert 17/03/2018 - 01:27
Sure please go ahead!
User 17/03/2018 - 01:27
ok
User 17/03/2018 - 01:28
so i hae a formula that returns the list you can see in column B
Excelchat Expert 17/03/2018 - 01:28
yes got it
User 17/03/2018 - 01:28
and now you have summed these for me
Excelchat Expert 17/03/2018 - 01:28
mmmhm
User 17/03/2018 - 01:29
i also have one more formula wait a second ill get it.
Excelchat Expert 17/03/2018 - 01:31
are you there?
User 17/03/2018 - 01:33
yes just a moment
Excelchat Expert 17/03/2018 - 01:33
Sure
Excelchat Expert 17/03/2018 - 01:34
Just give me 5mins
Excelchat Expert 17/03/2018 - 01:34
i will be back with this
User 17/03/2018 - 01:42
ok so i need to merge or add the formula i have in F5 to what you made me before so that the subtotals also take into account the start and end datesdates
User 17/03/2018 - 01:43
so basically a person can put in the start and end dates they wish and get subtotals and a grand total for the unique data in the list between those dates
User 17/03/2018 - 01:43
hello?
User 17/03/2018 - 01:46
are you there?
User 17/03/2018 - 01:50
helloooooooooo anybody home..home ..homehomehome
User 17/03/2018 - 01:50
i can hear my echo so i think the room is empty
User 17/03/2018 - 01:51
i guess I'm loosing my free time here
User 17/03/2018 - 01:54
HEY!!!!!!!!!!!!

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc