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.
  • Go back-and-forth until satisfied
    Rate the answer you receive.
Ask Jason Jones Your Own Question
Jason Jones
Jason Jones, Programmer
Category: Programming
Satisfied Customers: 30182
Experience:  Over 15 years of professional experience.
30759776
Type Your Programming Question Here...
Jason Jones is online now

I would like to know if there is a formula that can multiply

Customer Question

I would like to know if there is a formula that can multiply cells that have a number to another e.g. If Cell R22 to R1000 is not blank then multiply the cell that is not blank to the value on the same row and column A.
JA: Is there a specific language you're coding in?
Customer: E.g if cell R22, R34, R54 have numbers then multiply R22 by A22 + R34 by A34 + R54 by A54 without having to manually write each cell reference. Meaning there is a formula in place
JA: What's your objective? How can we solve this for you?
Customer: Write a formula on excel
JA: When did you last update Excel?
Customer: ..
JA: What have you tried so far with your Excel?
Customer: ...
JA: Anything else you want the Software Expert to know before I connect you?
Customer: no
Submitted: 1 year ago.
Category: Programming
Expert:  Jason Jones replied 1 year ago.

Hello,

Welcome to JustAnswer.com. My name is***** and I look forward to helping you.
I’m sorry to hear you're having trouble. I know that can be frustrating. Hopefully, we can get this resolved quickly.

Will leave formula have any rhythm or rhyme to it? For instance, will the formula always be looking at the 22nd, 34th, and 54th columns?

If you have an example of the document that you are working with, please upload it to this page by clicking the Send Files button.

Thank you,
Jason Jones

Customer: replied 1 year ago.
Will leave formula have any rhythm or rhyme to it? For instance, will the formula always be looking at the 22nd, 34th, and 54th columns?To answer above No
Customer: replied 1 year ago.
Before i allow you to connect i need to know if you can solve my problem
Customer: replied 1 year ago.
The list on the columns will keep increasing
Expert:  Jason Jones replied 1 year ago.

Please, give me a minute or two to look at your document. Thank you

Expert:  Jason Jones replied 1 year ago.

In which cells do you want the formulas placed?

Customer: replied 1 year ago.
R2, S2 and so on
Expert:  Jason Jones replied 1 year ago.

Thank you. I will have the formula posted in a couple minutes. Thank you

Customer: replied 1 year ago.
Thanks
Expert:  Jason Jones replied 1 year ago.

You are most welcome.

Customer: replied 1 year ago.
Please write the formula so that i can add 1000 rows
Expert:  Jason Jones replied 1 year ago.

ok

Customer: replied 1 year ago.
Will i be able to insert a row in between without affecting the formula?
Expert:  Jason Jones replied 1 year ago.

Yes

Customer: replied 1 year ago.
Great Stuff. Waiting for the Formula
Expert:  Jason Jones replied 1 year ago.

Thank you

Customer: replied 1 year ago.
Will you email me the formula? I have just got a call to leave
Expert:  Jason Jones replied 1 year ago.

Yes, I will post the formula on this page.

Customer: replied 1 year ago.
I shall wait a few minutes
Expert:  Jason Jones replied 1 year ago.

Thank you

Expert:  Jason Jones replied 1 year ago.

Thank you.

In the R2 cell, enter the following formula:

=SUMPRODUCT($A5:$A1005,R5:R1005*(R5:R1005>0))

Then you may copy that cell and paste it into the S2, T2, and so on.

Customer: replied 1 year ago.
Great - A small tweek to the formula
Customer: replied 1 year ago.
If the value in column R is negative it is not multiplying
Customer: replied 1 year ago.
Can you kindly amend that to multiply negative values?
Customer: replied 1 year ago.
This is needed for adding/substracting stock and sales
Expert:  Jason Jones replied 1 year ago.

Which cell in the R column are you referring to?

Expert:  Jason Jones replied 1 year ago.

If any of the values in the R column are negative, the product will be negative and it will subtract that row value from the total.

Customer: replied 1 year ago.
it is not doing that let me send you a document
Expert:  Jason Jones replied 1 year ago.

Please, be forewarned that the site is not secure:
- Click the following link: http://www.wikisend.com
- Upload the file to that website
- Once it is uploaded, the resulting page will display a "File ID" number.
- Please, give me that "File ID Number"

Customer: replied 1 year ago.
Here
Customer: replied 1 year ago.
Here is with negative
Expert:  Jason Jones replied 1 year ago.

Thank you

Customer: replied 1 year ago.
Can you change the formula?
Expert:  Jason Jones replied 1 year ago.

You may use this formula in R2 and copy it over:

=SUMPRODUCT($A5:$A1005,R5:R1005*(R5:R1005<>0))

Customer: replied 1 year ago.
Great Thanks
Expert:  Jason Jones replied 1 year ago.

You are most welcome. Thank you :)

Expert:  Jason Jones replied 1 year ago.

Hello,

Thank you for your time and patience today.

In the future, if you need any help with anything related to computers, cell phones, or anything in the electronics category, please let me know.

If you wish to work with me, Jason Jones, you may ask your question at the page listed below that you may bookmark/favorite. To be sure that it is sent to me, preface the question with -For Jason Jones Only!-

My Profile Page:

http://JasonFixedit.com

Customer: replied 1 year ago.
Thanks a lot
Customer: replied 1 year ago.
Bye
Customer: replied 1 year ago.
You can end the conversation.. I dont know how to
Expert:  Jason Jones replied 1 year ago.

After the rating is submitted, it will be closed.

Thank you. This will be the last message.