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 Kamil Anwar Your Own Question

Kamil Anwar
Kamil Anwar, Computer Support Specialist
Category: Computer
Satisfied Customers: 148
Experience:  8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.
69350257
Type Your Computer Question Here...
Kamil Anwar is online now

I have a column of generated date in the format of 23/05/15

Customer Question

I have a column of generated date in the format of 23/05/15 relating to the full year and against the dates are various cash amounts. I want to sort them onto another sheet into monthly columns with the cash values in their respective Monthly column.
I have changed the dates into a number and used the following but with result but zero =SUMIF('Maintenance Report'!D26,">=42156,<=42185",J27)
The above relates to a maintenance report for June 1st to 30th the value in cash shown in J27 of the report.
Hope you can assist
Submitted: 1 year ago.
Category: Computer
Expert:  Richard replied 1 year ago.
Thank you for your question, my name is ***** ***** I look forward to assisting you.
Please note, click on Reply to Expert to reply to me, a rating is only needed when we are finished.
Can i look at your file please as this will be easier to see what is happening.
- Click the following link: http://www.wikisend.com
- 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 1 year ago.
Relist: No answer yet.
I have downloaded the file and sent an email to Richard but have not yet received an answer.
Expert:  The-PC-Guy replied 1 year ago.
Thanks for using JustAnswer. My name is***** will do whatever I can to answer your question

would it be possible to send an example sheet

send to www.sendspace.com

after uploading they give you a download link

paste that link here
Customer: replied 1 year ago.
Expert:  The-PC-Guy replied 1 year ago.
i have the workbook.

Not following which range you are trying to sum. I understand you want to sum all values in a specific range that fall between 2 specific dates.

Which sheet and range contain the dates,

and which sheets and range contain the $ values that you want to sum.
Customer: replied 1 year ago.

Thank ou for coming back to me so soon.

The information comes in via sheet one Maintenance report and sheet two Quote Report and I am trying to basically do the same formula and data translation so it appears in Month order on sheet three "Cash Project Forecast.

Sheet four is only what I have created in order to try and solve the problem and put a numerical value against a date.

Now starting with Sheet 1 line two - "column C" contains the date I am interested in but it can be any day in any month and the report is unfiltered. The Value of the job is shown in "column J"

What I am trying to do is that when the report is dropped in on sheet one I would like Excel to decide that the dates in Column C on each line are within a particular month and then insert the value shown on Sheet One Column C onto sheet 3 under the correct month with the correct value.

EG.

1.Sheet1:Line2 :Column C, Response In - Sheet3:Line7:Column M, Value Inserted £4000

2.Sheet1:Line3 :Column C, Response In - Sheet3:Line8:Column O

Value Inserted £8500

3.Sheet1:Line4 :Column C, Response In - Sheet3:Line9:Column K

Value Inserted £1050

Hope this assists

Dave Brock

Customer: replied 1 year ago.

Sheet four is only what I have created in order to try and solve the problem and put a numerical value against a date.

Now starting with Sheet 1 line two - "column C" contains the date I am interested in but it can be any day in any month and the report is unfiltered. The Value of the job is shown in "column J"

What I am trying to do is that when the report is dropped in on sheet one I would like Excel to decide that the dates in Column C on each line are within a particular month and then insert the value shown on Sheet One Column C onto sheet 3 under the correct month with the correct value.

EG.

1.Sheet1:Line2 :Column C, Response In - Sheet3:Line7:Column M, Value Inserted £4000

2.Sheet1:Line3 :Column C, Response In - Sheet3:Line8:Column O

Value Inserted £8500

3.Sheet1:Line4 :Column C, Response In - Sheet3:Line9:Column K

Value Inserted £1050

Hope this assists

Dave Brock

Customer: replied 1 year ago.

Thank ou for coming back to me so soon.

The information comes in via sheet one Maintenance report and sheet two Quote Report and I am trying to basically do the same formula and data translation so it appears in Month order on sheet three "Cash Project Forecast.

Sheet four is only what I have created in order to try and solve the problem and put a numerical value against a date.

Now starting with Sheet 1 line two - "column C" contains the date I am interested in but it can be any day in any month and the report is unfiltered. The Value of the job is shown in "column J"

What I am trying to do is that when the report is dropped in on sheet one I would like Excel to decide that the dates in Column C on each line are within a particular month and then insert the value shown on Sheet One Column C onto sheet 3 under the correct month with the correct value.

EG.

1.Sheet1:Line2 :Column C, Response In - Sheet3:Line7:Column M, Value Inserted £4000

2.Sheet1:Line3 :Column C, Response In - Sheet3:Line8:Column O

Value Inserted £8500

3.Sheet1:Line4 :Column C, Response In - Sheet3:Line9:Column K

Value Inserted £1050

Hope this assists

Dave Brock

Expert:  The-PC-Guy replied 1 year ago.
i think I got you.

So if there is more than one value in one month, they should be added and displayed in the appropriate cell,

There is a formula that will do this, but it will not be able to skip rows. In other words all of the results would be in the same row on sheet, 3, all in row 7 for example.

If you want to skip rows for each value, then it will need a macro, which I can create for you.

The other option is to use a Pivot Table, and if you are not sure what that is I can create one for you. A pivot table basically makes a nice neet table in a separate sheet that can summarize data like this.

Let me know what you decide to do and I will provide a solution

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
< 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
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
  • 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
  • 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
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin
  • 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
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C.
 
 
 

Meet The Experts:

 
 
 
  • Kamil Anwar

    Kamil Anwar

    Computer Support Specialist

    Satisfied Customers:

    143
    8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.
< Last | Next >
  • http://ww2.justanswer.com/uploads/JA/JACUSTOMERf8udkdxk/2013-8-3_15150_323738101505074393259301621172992o.64x64.jpg Kamil Anwar's Avatar

    Kamil Anwar

    Computer Support Specialist

    Satisfied Customers:

    143
    8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.
  • http://ww2.justanswer.com/uploads/WI/Windowspcfix/2013-8-19_153826_ja12.64x64.jpg James K.'s Avatar

    James K.

    Consultant

    Satisfied Customers:

    93
    Technical Director of IT Company
  • http://ww2.justanswer.com/uploads/JO/JonTech/2011-10-25_111835_A2c.64x64.jpg Jon-Tech's Avatar

    Jon-Tech

    IS Manager

    Satisfied Customers:

    61
    20 yrs: Computers, Networking
  • http://ww2.justanswer.com/uploads/MI/mikew4950/2011-12-26_1606_mikephoto2s.64x64.jpg MikeW's Avatar

    MikeW

    Computer Engineer

    Satisfied Customers:

    49
    32+ years Computer and Networking Experience
  • http://ww2.justanswer.com/uploads/JA/jamieratliff/2012-2-8_194551_jamie.64x64.jpg jamieratliff's Avatar

    jamieratliff

    Information Systems Manager

    Satisfied Customers:

    21
    Jamie has worked in the Information Technology field for over a decade.
  • http://ww2.justanswer.com/uploads/JA/JACUSTOMERleg4q7o8/2012-3-6_203036_meja.64x64.png TheDoctor's Avatar

    TheDoctor

    Software Engineer

    Satisfied Customers:

    16
    Experienced Software Engineer
  • http://ww2.justanswer.com/uploads/FI/FisherEngineering/2012-1-18_194422_Fisher375Headshotcompressed239K.64x64.jpg Bill Fisher's Avatar

    Bill Fisher

    Computer Engineer

    Satisfied Customers:

    1
    Computer system design, networks, integration, general support.
 
 
 

Related Computer Questions