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.