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 Jess M. Your Own Question

Jess M.
Jess M., Computer Support Specialist
Category: Microsoft Office
Satisfied Customers: 6131
Experience:  Computer Software Specialist for more than 10 years
49766785
Type Your Microsoft Office Question Here...
Jess M. is online now
A new question is answered every 9 seconds

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

Customer Question

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: 9 months ago.
Category: Microsoft Office
Expert:  Jess M. replied 9 months ago.

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

Customer: replied 9 months ago.
let me know if this one works
Expert:  Jess M. replied 9 months 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.

Customer: replied 9 months ago.
I re-saved it so let me know if this works
Customer: replied 9 months ago.
still not working hold on
Expert:  Jess M. replied 9 months ago.

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

Customer: replied 9 months ago.
http://filesxpress.com/d-1f783f45 Here's the link
Expert:  Jess M. replied 9 months 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?

Customer: replied 9 months ago.
lol
Expert:  Jess M. replied 9 months ago.

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

Expert:  Jess M. replied 9 months 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

Customer: replied 9 months ago.
you are amazing!
Expert:  Jess M. replied 9 months 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