Solved

Formula Mis

Posted on 2014-02-20
9
256 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 19

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 19

Expert Comment

by:Raheman M. Abdul
ID: 39873097
Try this: =SUMPRODUCT(D3:GU3,E3:GV3)
0
Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

 
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
 
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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Cascading drop down lists in Excel 4 107
Excel Power Pivot - Aggregation 7 78
Adobe Acrobat Pro: how to copy style? 2 105
MS Excel: Conditional formatting with a time delay 7 42
This article describes how to use the Send to Mail Recipient command. The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific steps and figures.  What is Send to Mail Recipient? Send…
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…
This video walks the viewer through the process of creating an MLA formatted document, as well as a bibliography with citations.
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.

785 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