Solved

Formula Mis

Posted on 2014-02-20
9
253 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
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 
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

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

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…
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses. Navigate to the “Start Mail Merge” button in the Mailings tab: Follow the step-by-step process until asked to find the address doc…

746 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

11 Experts available now in Live!

Get 1:1 Help Now