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, Computer Support Specialist
Category: Computer
Satisfied Customers: 32013
Experience:  Over 15 years of consulting to the IT industry
32989067
Type Your Computer Question Here...
Richard is online now

I have uploaded anew file http://wikisend.com/download/436374/roger

Resolved Question:

I have uploaded anew file
http://wikisend.com/download/436374/roger march 13 op(NNN) NNN-NNNNxlsx
but it seems that it does not balance see column C and line 347 it is out by 118.21 in C351
can you find out where it is missing and correct and highlight the corrections
thank you roger
Submitted: 2 years ago.
Category: Computer
Expert:  Richard replied 2 years ago.
Thanks Roger,

Looking now
Expert:  Richard replied 2 years ago.
The calculations look correct Roger

How did you get the value for C349? As this is manually entered.

Customer: replied 2 years ago.

hi it is the same as B349

Expert:  Richard replied 2 years ago.
yes, but that is also manually entered Roger.

It is this figure that looks to be wrong, as all the calculations work out.

Where did you get the value for B349? As this is manually entered, not calculated.

Customer: replied 2 years ago.

B349 = C349 and must have entered it by hand but is the total of C which is total of sheet


roger

Expert:  Richard replied 2 years ago.
Looking now
Expert:  Richard replied 2 years ago.
Found the issue Roger

Rows 32, 36, 209, 218, 222 hasve totals but nothing in the columns eg: M,N,O,P ect

The totals of these equal 118.21 which is the missing amount


Customer: replied 2 years ago.

hi Richard


yes I see it now but to put this into the formulas would comp-licate the sheet more than it is now


I can just add this figure after I have looked at the empty lines


 


how do I take a report out of sheet to show me the empty line

Expert:  Richard replied 2 years ago.
Download my version Roger and then you can sort by K.

The values with blanks (Not True) are the empty ones.

http://wikisend.com/download/798312/roger march 13 op(NNN) NNN-NNNNxlsx

Let me know if you have any difficulties please
Customer: replied 2 years ago.

thanks Richard that formula works fine but can you rewrite it for column V as then my sheet is workable


regards

Expert:  Richard replied 2 years ago.
Of course,

I have done this and you can download it here

http://wikisend.com/download/509130/roger march 13 op(NNN) NNN-NNNNxlsx

If you have any problems, or would like any additional information or assistance, please do not hesitate to let me know.

And if you can take a second to rate my service, that would be greatly appreciated.

Thank you
Richard, Computer Support Specialist
Category: Computer
Satisfied Customers: 32013
Experience: Over 15 years of consulting to the IT industry
Richard and 4 other Computer Specialists are ready to help you

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:

    151
    8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.
< Previous | 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:

    151
    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:

    53
    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.