Solved

Formula Mis

Posted on 2014-02-20
9
254 Views
Last Modified: 2014-03-03
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
Comment
Question by:itjockey
  • 5
  • 2
  • 2
9 Comments
 
LVL 18

Expert Comment

by:Raheman M. Abdul
ID: 39873019
Can you be a bit more clear what you want to do please.
0
 
LVL 8

Author Comment

by:itjockey
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 18

Expert Comment

by:Raheman M. Abdul
ID: 39873097
Try this: =SUMPRODUCT(D3:GU3,E3:GV3)
0
 
LVL 8

Author Comment

by:itjockey
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
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 
LVL 85

Accepted Solution

by:
Rory Archibald earned 500 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

by:itjockey
ID: 39900168
Awesome thank you
0
 
LVL 8

Author Comment

by:itjockey
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

by:Rory Archibald
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

by:itjockey
ID: 39900271
Ok got it

Thanks
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Suggested Solutions

Microsoft Office 2010 is Microsoft's latest edition to their office productivity collection. It "promises to include rich and powerful new ways to deliver your best work". So to start off, I have to say that I'm slightly disappointed... That bei…
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…
The viewer will learn how to edit text. This includes Font, Spacing, Resizing, Color, and other special text options.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now