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 Richard Your Own Question
Richard
Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 38520
Experience:  Over 15 year experience resolving Microsoft Office Issues
32989067
Type Your Microsoft Office Question Here...
Richard is online now
A new question is answered every 9 seconds

I want to have a spreadsheet that contains columns with dates,

Resolved Question:

I want to have a spreadsheet that contains columns with dates, payment methods and dollar values. I want to be able to see a daily summary of the payments subtotaled by payment method. I have uploaded to wikisend an Excel spreadsheet that shows what a typical payment report looks like and added a sheet that shows how I would like it to look. Wikisend file ID is 323024.
Submitted: 4 years ago.
Category: Microsoft Office
Expert:  Lindie-mod replied 4 years ago.

Hi,
I'm a moderator for this topic. I've been working hard to find a Professional to assist you with your Microsoft, 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!
Lindie
Customer: replied 4 years ago.
Hello. Thanks for the reply and yes I can wait.
Expert:  Lindie-mod replied 4 years ago.
Hi

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

Lindie
Expert:  Richard replied 4 years ago.
Hi there and welcome

I am very sorry about the delay in answering.

To achieve this you will need to use a pivot table.

I have done this for you and uploaded the file. The ID is 699384

If you need any additional clarification or assistance, please do not hesitate to let me know.

Thank you
Richard, Software Specialist
Category: Microsoft Office
Satisfied Customers: 38520
Experience: Over 15 year experience resolving Microsoft Office Issues
Richard and 4 other Microsoft Office Specialists are ready to help you