Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
Solved

# Formula Mis

Posted on 2014-02-20
Medium Priority
265 Views
Hi Experts,

Need Excel Formula for Sum & Product.

I have Multiple columns need to multiplication & then Sum all to gather in Cell A3.

See attached File.

Thanks
Sideline.xlsx
0
Question by:Naresh Patel
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• 5
• 2
• 2

LVL 19

Expert Comment

ID: 39873019
Can you be a bit more clear what you want to do please.
0

LVL 8

Author Comment

ID: 39873041
There is formula in Cell A3. just need to know there is any different way out as I have 200 column to multiply & Sum the result.
0

LVL 19

Expert Comment

ID: 39873097
Try this: =SUMPRODUCT(D3:GU3,E3:GV3)
0

LVL 8

Author Comment

ID: 39881617
Sorry for delay I thought I had replied but I might get facing connectivity problem that time so my comment is not posed. this is my actual file pls look in to this. above formula may not work .

Thank You
Book1.xlsx
0

LVL 85

Accepted Solution

Rory Archibald earned 2000 total points
ID: 39900150
You could use:

=SUMPRODUCT((\$D\$2:\$M\$2="price")*D3:M3,E3:N3)

Note the final range needs to be offset one column from the other two.
0

LVL 8

Author Closing Comment

ID: 39900168
Awesome thank you
0

LVL 8

Author Comment

ID: 39900171
@Rory Archibald

Note the final range needs to be offset one column from the other two.

Dint Get it what do u mean by this.

Thanks
0

LVL 85

Expert Comment

ID: 39900245
In the example, the first two ranges are column D:M but the last one is E:N. Assuming you are adjusting these in the actual workbook, you need to make sure the last range is offset one column to the right of the other two.
0

LVL 8

Author Comment

ID: 39900271
Ok got it

Thanks
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will provide some simple productivity hacks that will help you use Google to specifically show results from any web site (Experts-Exchange.com in my example), with minimal effort in Chrome and Firefox. I've seen a common theme aâ€¦
With the internet and the ease of information transference, many professional jobs can be done anywhere today.Â  Why should it make a difference whether an x-ray is read in India or the United States as long as the radiologist is qualified? Â  Outsoâ€¦
The viewer will learn how to make their project stand out over others by learning how to change colors and shapes, add spaces, change directions, and add bullets to their charts.
XMind Plus helps organize all details/aspects of any project from large to small in an orderly and concise manner. If you are working on a complex project, use this micro tutorial to show you how to make a basic flow chart. The software is free whenâ€¦
###### Suggested Courses
Course of the Month9 days, 15 hours left to enroll