How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Jess M. Your Own Question

Jess M.
Jess M., Computer Support Specialist
Category: Microsoft Office
Satisfied Customers: 5892
Experience:  Computer Software Specialist for more than 10 years
Type Your Microsoft Office Question Here...
Jess M. is online now
A new question is answered every 9 seconds

HelloI have an excel sheet in which there is a column for

This answer was rated:


I have an excel sheet in which there is a column for due dates what i want is that when the date is due i want the amount being under another column to go to another worksheet under a column of the same month of the due date
Thank you for your question, my name is Richard.

Is this other worksheet in the same Excel file?
Customer: replied 3 years ago.

no it's in an another excel sheet

ok, can you upload both files please.

- Click the following link:
- Upload the file to that website
- Once it is uploaded, the resulting page will display a "File ID" number.
- Please, give me that "File ID Number"

Customer: replied 3 years ago.

331688 and 583176 the column of the due dates is in 583176 local column R

Can you tell me the file names, sheets and columns that are involved please.

Customer: replied 3 years ago.

yes the file name is XXXXX XXXXX orders list, local worksheet column R ( being the due dates ) and i want the column L once the date is due to flow to the other excel sheet being the projection, sheet 1, and the flowed number to be shower under the same month of the due date

ok,I think you mean Column T and not R?

And you want all the figures summed under the one month?

Customer: replied 3 years ago.

yes it's ok

Sorry I did not understand?
Customer: replied 3 years ago.

i mean yes its column T because the worksheet opened from your side is travel & hotels as for the figures yes i want them to be summed

ok, I will have to opt out for another expert sorry for this.

Customer: replied 3 years ago.
Relist: Other.
No answer received
I’m a moderator for this topic. It seems the Professional has left this conversation. This happens occasionally, and it's usually because the professional thinks that someone else might be a better match for your question. I've been working hard to find a new professional to assist you with your Question but sometimes finding the right professional can take a little longer than expected.

I wonder whether you're ok with continuing to wait for an answer. If you are, please let me know and I will continue my search. If not, feel free to let me know and I will cancel this question for you.

Thank you!
Customer: replied 3 years ago.




yes it's ok with me i will wait hopefully you will be able to find someone.




Thank you for your patience. We will continue the search for a professional for you.


Hi, welcome and thank you for your question. My name is XXXXX XXXXX I am glad to assist you today.

I am looking at your Ourchase Order List file. Column T is the Due Date. You mentioned about column L. When the date is due, the content of column L in Purchase Orders List file named PO Total will be copied to another excel file, called Projections.

Is this right? If so, in what cell in the Projections file will the data in column L be copied?

Please let me know so that I can help you further.

Best regards,
Customer: replied 3 years ago.

hi jess



the content in column L to be copied should go to the month of the same month in the due date




Please look at column L. L2 through L8 have due dates on April. Should these 7 entries go to B2 in Projections file? Or ONLY the sum of the 7 cells in L2:L8?

If you can provide sample computations, it will be better so that I can then incorporate a formula or logic in the Excel file.

Customer: replied 3 years ago.

yes i want all the due dates for a specific month to be summed together and shown in the projections sheet as one number ie: from L2 to L8 have due dates on April so in the projections sheet under April i should see the sum of L2 to L8

Thank you for that confirmation. Please give me a moment to try out a solution.


Thank you for patiently waiting. It really took me a lot of time to come up with what you really wanted or desired. I believe I was able to come up with the complete solution and here is the summary:
  1. You have 2 Excel files: PO List and Projections.
  2. In your PO list file, you need to determine entries that are DUE or NOT YET DUE.
  3. When an entry is DUE, you want to collect ALL DUE entries in the entire month and then SUM UP the PO Total values in column L.
  4. Place the SUM of the PO Totals in their corresponding months in Projections.xlsx file.

In order to accomplish this, I need to create a NEW sheet that will perform #2 above. I called the sheet Overdue_Status.


The purpose if this sheet is critical. It will convert the due date into months and it will test the entries if it is Overdue or Not Due. Also, I copied the PO Total values in Column L in this sheet.


Then, in order to push the SUM of all Overdue items, the formula will now test the conditions in the Overdue_Status sheet. The appropriate formula is SUMIFS(). In this case, You sum the PO Total column IF:

  1. The month shown in the Due Month column is equal to the month header. That is, for the April column (Projections sheet or file), Due Month must be April.
  2. The Status must be Overdue in the Status column.


In this case, only Overdue entries for the month of April will be totalled under April. The same logic applies in the other months.


Also, I added Projections sheet as a testing before I worked on the separate Projections file.


Here are the download links: Orders List 2013-4_jess.xlsx


NOTE: Since the Projections file is dependent on the PO List file, the 2 files must be saved in the SAME folder. Also, you can see the Projections sheet the results of the formulas that I made for you.


Please remember to rate my service positively (3-5 stars/faces) if this helped. Tips are always highly appreciated! Cool

If you have any other questions, please ask me or reply to me – I’ll be happy to respond.

Thank you!

Best regards,

Jess M., Computer Support Specialist
Category: Microsoft Office
Satisfied Customers: 5892
Experience: Computer Software Specialist for more than 10 years
Jess M. and 4 other Microsoft Office Specialists are ready to help you

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
< Previous | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
  • Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland

Meet The Experts:

  • jstinehelfer


    Information Systems Manager

    Satisfied Customers:

    A+ Comptia Certified computer repair
< Last | Next >
  • jstinehelfer's Avatar


    Information Systems Manager

    Satisfied Customers:

    A+ Comptia Certified computer repair
  • JasonJames122's Avatar


    Computer Enthusiast

    Satisfied Customers:

    I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business
  • Jess M.'s Avatar

    Jess M.

    Computer Support Specialist

    Satisfied Customers:

    Computer Software Specialist for more than 10 years
  • The-PC-Guy's Avatar


    Computer Manager

    Satisfied Customers:

    20 years experience providing remote computer support
  • James K.'s Avatar

    James K.


    Satisfied Customers:

    Technical Director of IT Company
  • IT Miro's Avatar

    IT Miro

    Computer Scientist

    Satisfied Customers:

    Bachelor's Degree in Information Technology, Microsoft Certified Professional
  • Chris L.'s Avatar

    Chris L.

    Support Specialist

    Satisfied Customers:

    Certified Expert with over 10 years experience.