Help Required in Multiplying...

[Deepak Sharma]

Hi Everyone,

I need to multiply and get the result with formula. Want to get a single formula to give the results for all the cells. Please see attached sheet.


Thanks and Regards,

 

[NARAYANK991]

Hi ,

I do not understand your requirement , but try these formulae :

=SUMPRODUCT(($E13:$G13) * A13)

=SUM(($E13:$G13)*TRANSPOSE($A13:$D13)) ; enter this as an array formula , using CTRL SHIFT ENTER.

=SUM(MMULT(TRANSPOSE(OFFSET($E13:$G13,,,5)),OFFSET($A13:$D13,,,5))) ; enter this as an array formula , using CTRL SHIFT ENTER.

Narayan

 

[Deepak Sharma]

Hi Narayan,

I need to multiply values like;
=A3*E3
=A3*F3
=A3*G3
Then Same for B, C & D

Conditions for formula can be column headings A,B,C,D OR 1,2,3

I was looking for a formula which can multiply the column heading with 1,2 & 3 values in different cells. As of now, I have to multiply by putting formula in each separate cells, which is very time-consuming.

Regards,

 

[NARAYANK991]

Hi ,

See if this is OK.

Narayan

 

[Deepak Sharma]

Wow! Amazing Brother.........Thank you so much !!!

Regards,