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: 44547
Experience:  Over 15 years of consulting to the IT industry
Type Your Computer Question Here...
Richard is online now

Help with a spreadsheet stock, and a formula that

This answer was rated:

help with a spreadsheet for drinks stock, and a formula that decides where to use one column of another ... thinking sumif or if or choose but a bit stuck, need help now
Thank you for your question, my name is ***** ***** I look forward to assisting you.
Please note, click on Reply to Expert to reply to me, a rating is only needed when we are finished.
Can I look at the file and can you tell me exactly the columns involved and what you want to achieve please?
To give me the file
Go to
Upload the file, and provide me the download link please.
Customer: replied 2 years ago.

ok - columns A + B tell me what I need to order.

J + K will update A + B

difference between A/B is just /6 as 6 drinks per pack.


To put in values into J OR K which will update A + B .

not sure how to do this. ask if more info required or adaminnit sky pe

ok, ill look at it now Adam
ok.. so if you put in 1 in K it should inxrease the value of both A and B by 6 Adam?
Customer: replied 2 years ago.

if you put 1 in K it should DECREASE A by 6 and B by 1.

if you put 1 in J it should DECREASE A by 1 and B by 1/6

Then in A3 use
And copy it down
And B3 use
And copy it down
Not sure if in B you need A3/6 but I left it there as you already had it
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 by clicking one of the stars at the top of the screen and then submit, that would be greatly appreciated.
Thank you
Richard and other Computer Specialists are ready to help you
Customer: replied 2 years ago.

spot on - thank you.

Your welcome
If you need anything else, let me know and please remember the service rating by clicking one of the stars at the top.