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
LVL 8
Naresh PatelTraderAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

 
Raheman M. AbdulSenior Infrastructure Support Analyst & Systems DeveloperCommented:
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. AbdulSenior Infrastructure Support Analyst & Systems DeveloperCommented:
Try this: =SUMPRODUCT(D3:GU3,E3:GV3)
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
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

Experts Exchange Solution brought to you by ConnectWise

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.