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: 38519
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: 3 years ago.
Category: Computer
Expert:  Richard replied 3 years ago.
Thanks Roger,

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

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

Customer: replied 3 years ago.

hi it is the same as B349

Expert:  Richard replied 3 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 3 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 3 years ago.
Looking now
Expert:  Richard replied 3 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 3 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 3 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 3 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 3 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 and 5 other Computer Specialists are ready to help you