Microsoft Office

Microsoft Office questions? Ask an IT Expert for support ASAP

Ask a Computer Expert,
Get an Answer ASAP!

This answer was rated:

I have an excel spreadsheet that is basically a cost

calculator I have put together...
I have an excel spreadsheet that is basically a cost calculator I have put together for my wife, but I can't get some of the cells to show the totals as the cells are formulas of other cells but with total results. My wife will need to use those cells in columns A, B, F, and J for each project she works on and each of these will differ according to her projects, and the totals will change accordingly and some of the blank cells will be used for other projects. But as I have done it, the totals in some of the cells are showing error messages (#DIV/0!) which I am hoping you can remove these messages and allow the blanks to show the totals. I have given an example in the spreadsheet to show you what is happening. My wife will need to use only what she needs in columns A, B, F and J which will change for each project, but she needs to be able to cost out each project and it doesn't show the totals as it stands. Can you do a fix around for me so the totals will always show no matter if she fills all of the cells or just a few in the table. Could you also include a calculate button beside the total figure shown at cells 7-9. Please note DO NOT delete the unused cells as this spreadsheet will become a template for other projects and as such will need to have the blank cells included.
Show More
Show Less
Ask Your Own Microsoft Office Question
Answered in 3 minutes by:
3/15/2018
Jess M.
Jess M., Computer Support Specialist
Category: Microsoft Office
Satisfied Customers: 8,123
Experience: Computer Software Specialist for more than 10 years
Verified

Hi, welcome and thank you for your question. My name is ***** ***** I am glad to assist you today.
I am very sorry about your issues. Few things first:

  1. What version of Excel are you using?
  2. Can you please attach a sample or dummy of your Excel file in your reply using the Add Files button or Paper clip icon? (You can remove the confidential info on the file but please retain the other data so that I can work on them)

Please let me know by replying to me here so that I can help you further.
Best regards,
Jess

Ask Your Own Microsoft Office Question
Customer reply replied 5 months ago
I am using the latest version - ver 15.33 excel for mac. I have attached the file now

Thank you. Please give me a moment to download and check the problem on the file you attached. I will be back in a while.

Ask Your Own Microsoft Office Question

Let us take for instance K23. It is an error now since the rows above it have errors to. The function is a SUM. Do you want to just take the SUM for NON-BLANK rows like rows 4 to 10? So for K23 (and similar case to other columns) the SUM should be $150.87. Am I correct?

Ask Your Own Microsoft Office Question
Customer reply replied 5 months ago
But also there will be times when some of the blank cells all have numbers as the spreadsheet is designed to include other cells as necessary for different projects. So I may need to include additional cells as there may be more cells used per project.

I understand. The spreadsheet should be ready with the needed formula and logic so that when your wife enters the project data, all calculations are working. Please let me continue.

Ask Your Own Microsoft Office Question
Customer reply replied 5 months ago
thanks. I have to go out for a while now but will respond when I return later today.

Thank you for your patience. I have fixed the formulas. The errors you were getting were due to division of zeros. The formula is division and you have blank cells. Then when those cells are summed, the result will be an error.

To fix the problem, I enclosed your formula with IFERROR() function. The logic is, if the result is an error (like !Div0#), it will make the cell blank. Thus, when the cells are summed, these blank cells are ignored and only those with values are added.

Also, I noticed that you used SUM() in all your functions even when the main calculation is a division like SUM(E4/F4). I removed the SUM and made the formula E4/F4 since it will be easy or quick to understand and maintain in the future.

Here is the completed file and it should be ready to accept project data!

http://filesxpress.com/d-f4975aa2

I hope that helped.

Please remember to rate my service positively (3-5 stars/faces) if this helped. Tips are always highly appreciated!

If you need further assistance, please do not rate me negatively with 1 or 2 faces. Instead, please reply to me so that I can help you further.

Thank you!

Best regards,
Jess

Jess M.
Jess M., Computer Support Specialist
Category: Microsoft Office
Satisfied Customers: 8,123
Experience: Computer Software Specialist for more than 10 years
Verified
Jess M. and 87 other Microsoft Office Specialists are ready to help you
Ask your own question now
Customer reply replied 5 months ago
Thanks Jess. That has worked!

You're welcome and thank you for using our service.

If you need assistance in the future, you can request me any time by posting a new question starting with "For Jess M" so that I can assist you immediately.

Best regards,
Jess

Ask Your Own Microsoft Office Question
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a microsoft office technicianLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask Jess M. Your Own Question
Jess M.
Jess M.
Jess M., Computer Support Specialist
Category: Microsoft Office
Satisfied Customers: 8,123
8,123 Satisfied Customers
Experience: Computer Software Specialist for more than 10 years

Jess M. is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

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 CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

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!!!!

AlexLos Angeles, CA

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.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

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.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

jstinehelfer

jstinehelfer

Information Systems Manager

36 satisfied customers

A+ Comptia Certified computer repair

JasonJames122

JasonJames122

Computer Enthusiast

0 satisfied customers

I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business

Jess M.

Jess M.

Computer Support Specialist

8,123 satisfied customers

Computer Software Specialist for more than 10 years

The-PC-Guy

The-PC-Guy

Computer Manager

653 satisfied customers

20 years experience providing remote computer support

James K.

James K.

Consultant

260 satisfied customers

Technical Director of IT Company

Kamil Anwar

Kamil Anwar

Office Specialist

219 satisfied customers

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

IT Miro

IT Miro

Computer Scientist

160 satisfied customers

Bachelor's Degree in Information Technology, Microsoft Certified Professional

< Previous | Next >

Related Microsoft Office Questions
I have extended my calculator to include a few other columns
Hello again, I have extended my calculator to include a few other columns and functions and now some of my cells are showing zeros when they should show a blank but still keeping the formulas. For exa… read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
8,123 satisfied customers
Sorry everyone, I just need to discuss something with Zabo04
Sorry everyone, I just need to discuss something with Zabo04 who has done some prior work with me.… read more
Zabo04
Zabo04
Master\u0027s Student
Master\u0027s Degree
7 satisfied customers
Need a formula or way to get the same profit margin no
Need a formula or way to get the same profit margin no matter what service or product is sold. I'm in construction and need to make the same on every job. I have a speed sheet set up now but have to r… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
653 satisfied customers
Whats the formula for adding all those cells but when a
Whats the formula for adding all those cells but when a negative number appears not have it included in addition? let all negative numbers be ignored!! Cell A =1 B=2 C=-3 D=4… read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
I want to create a spreadsheet that contains a monthly
I want to create a spreadsheet that contains a monthly average of a metric that I receive daily. What formula can I use to add a number daily to an existing average without seeing the previous numbers… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
653 satisfied customers
I am looking to create a spreadsheet where I can input a
I am looking to create a spreadsheet where I can input a real estate agents gross commission income (GCI) for the year and it will calculate their net based on a sliding scale. For example: -50% of GC… read more
Russell H.
Russell H.
Computer Technology Consultant
Vocational, Technical or Trade Scho
791 satisfied customers
I have a 1,000 + line item list of product sales bought by
I have a 1,000 + line item list of product sales bought by customers. Customer A buys 3 different products or multiple purchases of the same product. I am trying to find a way to total all sales for a… read more
Bruce Wilner
Bruce Wilner
Master of Engineering
30 satisfied customers
Ok so in column A I have different variables but with the
Ok so in column A I have different variables but with the same formula. I.e. A1 is 1.5*1000/29.57/1.5 , A2 is .7*1000/29.57/1.5 how do I create a formula for the entire column but with changing the ce… read more
Zabo04
Zabo04
Master\u0027s Student
Master\u0027s Degree
7 satisfied customers
I am running an Excel spreadsheet and have created cocktail
I am running an Excel spreadsheet and have created cocktail recipes, now i want to calculate how many ml in of each ingredient appears in the recipes in a breakdown on the right hand side of the sprea… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
653 satisfied customers
I am working on/analyzing an Excel file with nearly 1000 data
I am working on/analyzing an Excel file with nearly 1000 data entries. I'm using AutoFilter to see if some of the items happen multiple times. Is there a quick and simple way to find out: 1. How many … read more
Zabo04
Zabo04
Master\u0027s Student
Master\u0027s Degree
7 satisfied customers
I need a formula that will allow me to calculate data from
I need a formula that will allow me to calculate data from columns into number of daily visits by staff to clients seen per day. I have a column with date of visit, another column with staff name (e.g… read more
Zabo04
Zabo04
Master\u0027s Student
Master\u0027s Degree
7 satisfied customers
I have some test equipment (strain gauge) which generates
I have some test equipment (strain gauge) which generates numbers in a single column (A) in an excel (2003) spreadsheet. These numbers are generated in any order and there are about 6500 of them. I wi… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
653 satisfied customers
I need a formula in this excel spreadsheet. calculate the
I need a formula in this excel spreadsheet. calculate the number of listings an agent has by finding agent in column A in column F and returning value of column G PLUS finding that same agent's name i… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,474 satisfied customers
I need help creating a spreadsheet that tracks our vacation,
I need help creating a spreadsheet that tracks our vacation, holiday and paid time off based on hire date Vacation - Each employee is entitled to 5 days in year one of employment and then from year 2-… read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
8,123 satisfied customers
Need excel help:Sheet has 77 rows, columns used A-K.Column
Need excel help: Sheet has 77 rows, columns used A-K. Column G has # XXXXX instances, the sum of all instances is in G78. Column I has the percentage of the sum that those instances represent. What Ha… read more
Steve
Steve
Consultant
Bachelor
69 satisfied customers
Need Excel spreadsheets for NPV & IRR computations
I watched the video on teach excel.com on about computing Net present Values (NPV) and IRR's; I thought I could download a spreadsheet (excel) to practice with, where do I go and what is the link? I a… read more
toughguy
toughguy
Master\u0027s Degree
210 satisfied customers
Good Morning,I need help writing an Excel Formula. Following
Good Morning, I need help writing an Excel Formula. I realize that I am on an unlimited subscription plan but am will to pay a $15 bonus for a working answer. That being said the following are the cri… read more
Pete
Pete
Engineer
Bachelor\u0027s Degree
1,131 satisfied customers
In an Excel spreadsheet, how can I assign a numerical value
In an Excel spreadsheet, how can I assign a numerical value to a text item. For example: in a spreadsheet with thousands of instances of "product A", "service B", "other item X" etc., where certain to… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
653 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x