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: 23671
Experience:  Over 10 years of work 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: 2 months ago.
Category: Programming
Expert:  Jason Jones replied 2 months 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 2 months 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 2 months ago.
Before i allow you to connect i need to know if you can solve my problem
Customer: replied 2 months ago.
The list on the columns will keep increasing
Expert:  Jason Jones replied 2 months ago.

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

Expert:  Jason Jones replied 2 months ago.

In which cells do you want the formulas placed?

Customer: replied 2 months ago.
R2, S2 and so on
Expert:  Jason Jones replied 2 months ago.

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

Customer: replied 2 months ago.
Thanks
Expert:  Jason Jones replied 2 months ago.

You are most welcome.

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

ok

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

Yes

Customer: replied 2 months ago.
Great Stuff. Waiting for the Formula
Expert:  Jason Jones replied 2 months ago.

Thank you

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

Yes, I will post the formula on this page.

Customer: replied 2 months ago.
I shall wait a few minutes
Expert:  Jason Jones replied 2 months ago.

Thank you

Expert:  Jason Jones replied 2 months 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 2 months ago.
Great - A small tweek to the formula
Customer: replied 2 months ago.
If the value in column R is negative it is not multiplying
Customer: replied 2 months ago.
Can you kindly amend that to multiply negative values?
Customer: replied 2 months ago.
This is needed for adding/substracting stock and sales
Expert:  Jason Jones replied 2 months ago.

Which cell in the R column are you referring to?

Expert:  Jason Jones replied 2 months 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 2 months ago.
it is not doing that let me send you a document
Expert:  Jason Jones replied 2 months 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 2 months ago.
Here
Customer: replied 2 months ago.
Here is with negative
Expert:  Jason Jones replied 2 months ago.

Thank you

Customer: replied 2 months ago.
Can you change the formula?
Expert:  Jason Jones replied 2 months ago.

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

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

Customer: replied 2 months ago.
Great Thanks
Expert:  Jason Jones replied 2 months ago.

You are most welcome. Thank you :)

Expert:  Jason Jones replied 2 months 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 2 months ago.
Thanks a lot
Customer: replied 2 months ago.
Bye
Customer: replied 2 months ago.
You can end the conversation.. I dont know how to
Expert:  Jason Jones replied 2 months ago.

After the rating is submitted, it will be closed.

Thank you. This will be the last message.