Microsoft Office

Microsoft Office questions? Ask an IT Expert for support ASAP

Ask a Computer Expert,
Get an Answer ASAP!

I want to exclude "0" from an if formula. The

Customer Question
Hello, I want to exclude...
Hello, I want to exclude "0" from an if formula. The formula sums up the 1st 4 weeks at point of sale but I do not want to count "0".
Submitted: 2 years ago.Category: Microsoft Office
Show More
Show Less
Ask Your Own Microsoft Office Question
Answered in 3 minutes by:
2/17/2016
Microsoft Office Technician: Jess M., Computer Support Specialist replied 2 years ago
Jess M.
Jess M., Computer Support Specialist
Category: Microsoft Office
Satisfied Customers: 7,875
Experience: Computer Software Specialist for more than 10 years
Verified

Thank you for your question. The attached file is corrupted, maybe during upload. Please attach the file again so that I can check it.

Ask Your Own Microsoft Office Question
Customer reply replied 2 years ago
let me know if this one works
Microsoft Office Technician: Jess M., Computer Support Specialist replied 2 years ago

Still not working. You can try clicking on the attachment link yourself to see the error.

I suggest that you upload it in this site:

http://filesXpress.com

Then give me the short download link.

Ask Your Own Microsoft Office Question
Customer reply replied 2 years ago
I re-saved it so let me know if this works
Customer reply replied 2 years ago
still not working hold on
Microsoft Office Technician: Jess M., Computer Support Specialist replied 2 years ago

Not working. Please upload it to http://filesXpress.com

Ask Your Own Microsoft Office Question
Customer reply replied 2 years ago
http://filesxpress.com/d-1f783f45 Here's the link
Microsoft Office Technician: Jess M., Computer Support Specialist replied 2 years ago

I got it. So this was the formula I created for you before. So now you want to exclude 0s, that means, you will enter 0, you want to NOT include it thus you need to start in the next cell. Correct?

For instance, in your sample the cells have values:

0 1 3 2 2

Since 0 is counted, the formula calculates 0+1+3+2 = 6.

Now you want it to be 1+3+2+2 = 8.

Is that correct?

Ask Your Own Microsoft Office Question
Customer reply replied 2 years ago
lol
Microsoft Office Technician: Jess M., Computer Support Specialist replied 2 years ago

Thank you for that confirmation. Please give me a moment to rebuild the formula for you.

Ask Your Own Microsoft Office Question
Microsoft Office Technician: Jess M., Computer Support Specialist replied 2 years ago

Thank you for patiently waiting.

I have completed the required modification and here is the completed file:

http://filesxpress.com/download-9a0abb7b89c626245dd600563c73a4ca

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

Ask Your Own Microsoft Office Question
Customer reply replied 2 years ago
you are amazing!
Microsoft Office Technician: Jess M., Computer Support Specialist replied 2 years ago

Thank you and I am glad to be of help.

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: 7,875
7,875 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

7,875 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 just purchased office 365, for my new laptop. My main
Hi, I have just purchased office 365, for my new laptop. My main issue is my email. I was on windows live 12 (I think) and want to move it to outlook 16. I have loaded 365 on my new laptop. If I deact… read more
Jess M.
Jess M.
Computer Support Specialist
7,875 satisfied customers
How can I put an end to being forced to change my password?
How can I put an end to being forced to change my password? I have just had to change it again, for the second time in less than a week. Thank you. … read more
Jess M.
Jess M.
Computer Support Specialist
7,875 satisfied customers
Vickie Howman Here I was on line with your technician to fix
Hi Vickie Howman Here I was on line with your technician Peter to fix the problem with Office 365 and left me in the lurch!! need to say I am upset … read more
Jess M.
Jess M.
Computer Support Specialist
7,875 satisfied customers
Two days ago I changed the credit card that pays for my word
Two days ago I changed the credit card that pays for my word subscription that was renewed today. Since I changed the card Word has not worked … read more
UranIT
UranIT
IT Consultant, Network and System Admin
Associate Degree
932 satisfied customers
I am billed periodically for for Office 365 Personal
I am billed periodically for for Office 365 Personal Services. I received a notice a while ago that the credit card I was using to pay the bill through PayPal needed to be updated. I did that. The Vis… read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
I keep getting phone calls that my Microsoft program will be
I keep getting phone calls that my Microsoft program will be turned off. I am very suspicious of any unsolicited phone calls. Can you help me confirm is this is legitimate … read more
Jess M.
Jess M.
Computer Support Specialist
7,875 satisfied customers
I got a email with a 065 message encryption from my doctor.
I got a email with a 065 message encryption from my doctor. I get a dark screen when I open it. my email is***@******.*** … read more
Ameen Khan
Ameen Khan
Senior IT Support Specialist
Information Technology Management / Computer Science
31 satisfied customers
All of a sudden, when I open an old file, change it and save
All of a sudden, when I open an old file, change it and save the new document under a new name, the old file disappears. How can I prevent this? I've lost two important files. … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,439 satisfied customers
MY office 2016 stopped functioning after I rebooted my
MY office 2016 stopped functioning after I rebooted my computer … read more
Viet - Computer Tech
Viet - Computer Tech
Computer Technican
Bachelor\u0027s Degree
969 satisfied customers
I have a formula that calculates total time worked, and I
I have a formula that calculates total time worked, and I put "X"s in when they are not. the formula does not register the "X"s and it appears in the formula box as #VALUE! How do I get the X's to not… read more
Jess M.
Jess M.
Computer Support Specialist
7,875 satisfied customers
I am having problems with my office words and i seem to get
i am having problems with my office words and i seem to get half pictures when i do insert … read more
Mr.Med
Mr.Med
1,153 satisfied customers
I have a problem with my Word program. Someway somehow every
I have a problem with my Word program. Someway somehow every time I open a new document on Word to do a letter or any kind of document the cursor starts at the very top of the page even though I alrea… read more
Viet - Computer Tech
Viet - Computer Tech
Computer Technican
Bachelor\u0027s Degree
969 satisfied customers
I cancelled 365 last week I was charged on my Visa today.
I cancelled 365 last week I was charged on my Visa today. … read more
John Castle
John Castle
BSC in Computing Network Management and Design
78 satisfied customers
Cannot sync office calendar with my I pad. Windows 10. Only
only recently all of a sudden I have 3 different calendars on my pc … read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
Sorry we cant get to your account right now" Office 2016.
quot;Sorry we cant get to your account right now" Office 2016 … read more
Mike Taylor
Mike Taylor
44 satisfied customers
I just renewed 365 and it will not activate. Word. Down
I just renewed 365 and it will not activate JA: What application are you using? Customer: word JA: When did you last update Word? Customer: down loaded office 5 minutes ago JA: What have you tried so … read more
John
John
System/Network administrator
High School or GED
2,073 satisfied customers
I need to know if I renewed office 365 this year. I was ill
I need to know if I renewed office 365 this year. I was ill and things are a stray. I can find I did it on 4/14/17. … read more
Cody
Cody
Computer Science
2,371 satisfied customers
I could not gt the email you sent me.Could we start again.
I could not gt the email you sent me.Could we start again … read more
John Castle
John Castle
BSC in Computing Network Management and Design
78 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