Hard to Explain: Date - Profit lookup & Summary
Good Afternoon,
Question. I have an excel spreadsheet that I use to track all my social media posts and data. I am trying to build a summary tab now with Month & Net Profit. Basically, with my hundreds of posts that I put out per month, I wish to have this new tab scan my DATE column and PROFIT column to produce a Currency Figure for JAN, FEB, etc...
I am unsure if this is possible,
Suggestions?
1.PNG
techxcellent welcome to the forum.
You often get more and faster response if you upload a sample Excel (*.xlsx) file instead of screen shots. It saves having to recreate what you already have.
If you are unfamiliar with how to do this:
To attach a file to your post,
- click “Go Advanced” (next to Post Quick Reply – bottom right),
- scroll down until you see “Manage Attachments”, click that,
- click “Browse”.
- select your file(s)
- click “Upload”
- click “Close window”
- click “Submit Reply”
- be sure to desensitize the data
The file name will appear at the bottom of your reply.
Dave
Thank you for the suggestion FlameRetired.
Please see the attached Excel Work Book. You will find the area in question under the Social Media Data tab.
Thank you,
Try
J4=SUMPRODUCT((Table5[PROFIT])*(TEXT(Table5[DATE],"MMM")=I4))
and drag down
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Thank you, shukla.ankur281190
The suggestion didn't work. When I attached =Sum to the beginning, it didn't work, just stated #NAME?
I have attached v2 of the document under the Social Media Data tab.
You have putted =SumG3=SUMPRODUCT((Table5[PROFIT])*(TEXT(Table5[DATE],"DD.MM.YYYY")=B3)) instead of =SUMPRODUCT((Table5[PROFIT])*(TEXT(Table5[DATE],"DD.MM.YYYY")=B3))
Check the attached file.
Thank you,
I ran a test and entered in the following date: 01.07.2012, however the 1 dollar profit was listed in FEB and not in July.
Am I missing something?
Document attached.
Try only what I am saying
J4and drag down in sheet Social Media Data.Formula:
Please Login or Register to view this content.
Change months as below.
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Thank you,
Done.
It went rather wierd though.
Attached for your review & Changed everything according to your instructions.
Check the attached file.
Thank you,
Nothing is happening.
Attached.
But here you attached file is working great can you once press F2 on J3 cell and enter...???
I do apologize, I didn't know about the pressing F2 part.
Is this going to be always required?
Also, when I do press F2 on J3 (labelled NET PROFIT), nothing happens at all.
Update: I have tried the F2 and enter on all the other cell's as well JAN to DEC. Still, nothing.
Last edited by techxcellent; 05-09-2017 at 03:50 AM.
Check the attached file as try to make entries and see the cells are automatically updating or not.
Worked.
Thank you.
So I can learn from this, what did you do differently from my last update to this upload?
Calculation option was marked manual instead automatically.
Go to the formula tab ->>> under Calculation ->>> click on Calculation option and check marked on Automatic.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks