• 100% Satisfaction Guarantee

Richard, Computer Support Specialist
Category: Computer
Satisfied Customers: 32153
Experience:  Over 15 years of consulting to the IT industry
32989067
Richard is online now

# Help with a spreadsheet stock, and a formula that

### Resolved Question:

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
Submitted: 1 year ago.
Category: Computer
Expert:  Richard replied 1 year ago.
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 http://ge.tt
Customer: replied 1 year ago.

http://ge.tt/1AU72iH2/v/0?c

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.

Problem:

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

Expert:  Richard replied 1 year ago.
ok, ill look at it now Adam
Expert:  Richard replied 1 year ago.
ok.. so if you put in 1 in K it should inxrease the value of both A and B by 6 Adam?
Customer: replied 1 year 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

Expert:  Richard replied 1 year ago.
Thanks
Then in A3 use
=SUM(F3+G3+H3)-(K3*6)-(J3)
And copy it down
And B3 use
=A3/6-K3-(J3/6)
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, Computer Support Specialist
Category: Computer
Satisfied Customers: 32153
Experience: Over 15 years of consulting to the IT industry
Customer: replied 1 year ago.

spot on - thank you.

Expert:  Richard replied 1 year ago.
If you need anything else, let me know and please remember the service rating by clicking one of the stars at the top.
Thanks

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

### Bill Fisher

#### Satisfied Customers:

1
Computer system design, networks, integration, general support.