Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 270
  • Last Modified:

Formula Mis

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
Naresh Patel
Asked:
Naresh Patel
  • 5
  • 2
  • 2
1 Solution
 
Raheman M. AbdulCommented:
Can you be a bit more clear what you want to do please.
0
 
Naresh PatelTraderAuthor Commented:
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
 
Raheman M. AbdulCommented:
Try this: =SUMPRODUCT(D3:GU3,E3:GV3)
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Naresh PatelTraderAuthor Commented:
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
 
Rory ArchibaldCommented:
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
 
Naresh PatelTraderAuthor Commented:
Awesome thank you
0
 
Naresh PatelTraderAuthor Commented:
@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
 
Rory ArchibaldCommented:
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
 
Naresh PatelTraderAuthor Commented:
Ok got it

Thanks
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 5
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now