### How JustAnswer Works:

• Ask an Expert
• Get a Professional Answer
• 100% Satisfaction Guarantee

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

### Resolved Question:

I have uploaded anew file
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.

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

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.

• ### Kamil Anwar

#### Satisfied Customers:

151
8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.
< Previous | Next >

### Kamil Anwar

#### Satisfied Customers:

151
8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.

### James K.

#### Satisfied Customers:

93
Technical Director of IT Company

### Jon-Tech

#### Satisfied Customers:

61
20 yrs: Computers, Networking

### MikeW

#### Satisfied Customers:

53
32+ years Computer and Networking Experience

### jamieratliff

#### Satisfied Customers:

21
Jamie has worked in the Information Technology field for over a decade.

### TheDoctor

#### Satisfied Customers:

16
Experienced Software Engineer