Naresh Patel
asked on
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
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
Can you be a bit more clear what you want to do please.
ASKER
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.
Try this: =SUMPRODUCT(D3:GU3,E3:GV3)
ASKER
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
Thank You
Book1.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Awesome thank you
ASKER
@Rory Archibald
Dint Get it what do u mean by this.
Thanks
Note the final range needs to be offset one column from the other two.
Dint Get it what do u mean by this.
Thanks
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.
ASKER
Ok got it
Thanks
Thanks