Question description:
This user has given permission to use the problem statement for this
blog.
i need a formula that can take the dates from a column and add the amount of data that is attached to each date into a single amount for that date
EX: on 4/17 - 6 and on 4/18 - 3
4/17 - 2
4/17 - 2
4/17 - 2
4/18 - 3
Solved by K. D. in 6 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
20/04/2018 - 03:03
Hi
Excelchat Expert
20/04/2018 - 03:03
Welcome to Got it Pro
Excelchat Expert
20/04/2018 - 03:03
Hi
User
20/04/2018 - 03:03
hello, thanks
Excelchat Expert
20/04/2018 - 03:03
Can you paste your sample data so that i can help you better
User
20/04/2018 - 03:04
do you see what i am trying to do?
User
20/04/2018 - 03:05
the list will go on for months... i have to take this data and put in a graph form as well
Excelchat Expert
20/04/2018 - 03:05
Do you want to sum against this date?
User
20/04/2018 - 03:05
yes
Excelchat Expert
20/04/2018 - 03:05
See the formula in F7
User
20/04/2018 - 03:05
yes
Excelchat Expert
20/04/2018 - 03:05
Does this help?
Excelchat Expert
20/04/2018 - 03:05
Cool
Excelchat Expert
20/04/2018 - 03:06
Do you need anything else?
User
20/04/2018 - 03:06
can this be carried on
Excelchat Expert
20/04/2018 - 03:06
Carried on as in?
User
20/04/2018 - 03:06
when i add more data
Excelchat Expert
20/04/2018 - 03:07
Yes you can adjust the formula accordingly
User
20/04/2018 - 03:07
so it might be more dates
Excelchat Expert
20/04/2018 - 03:07
Yes
Excelchat Expert
20/04/2018 - 03:07
See
Excelchat Expert
20/04/2018 - 03:08
I added more date and then dragged down the formula
Excelchat Expert
20/04/2018 - 03:08
It works
User
20/04/2018 - 03:08
i see
User
20/04/2018 - 03:08
how can i get help again
Excelchat Expert
20/04/2018 - 03:08
You can again come to got it pro
Excelchat Expert
20/04/2018 - 03:08
Whenever you need any help
Excelchat Expert
20/04/2018 - 03:09
Please do give good rating for this session
Excelchat Expert
20/04/2018 - 03:09
It really helps
User
20/04/2018 - 03:09
sure thing. thank you
Excelchat Expert
20/04/2018 - 03:09
Welcome
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.