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

I have uploaded anew file

This answer was rated:

I have uploaded anew file 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
Thanks Roger,

Looking now
The calculations look correct Roger

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

Customer: replied 4 years ago.

hi it is the same as B349

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 4 years ago.

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


Looking now
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 4 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

Download my version Roger and then you can sort by K.

The values with blanks (Not True) are the empty ones. march 13 op(NNN) NNN-NNNNxlsx

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

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


Of course,

I have done this and you can download it here 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 2 other Computer Specialists are ready to help you