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

Senior Infrastructure Support Analyst & Systems DeveloperCommented:
Can you be a bit more clear what you want to do please.
0

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

Senior Infrastructure Support Analyst & Systems DeveloperCommented:
Try this: =SUMPRODUCT(D3:GU3,E3:GV3)
0

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

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

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

Awesome thank you
0

@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

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

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.