Help required for Sumproduct formula

[shreyans goyal]

I have a table as shown below.
I need to calculate sum of product a*c each. Result would be like
1*3+1*4+1*5=12

    A  B  C  D  E  F  G  H  I  J  K  L
1  a   b  c  d   a  b  c  d  a  b  c d
2 1   2   3  2  1  2  4  2  1  2  5 2

Thanks in advance.

 

[Faseeh]

If you want to multiply a series of numbers and they are present in range A1:C1 and you want to multiply it with a number say 2 then formula should be

=SUMPRODUCT(2*A1:C3)

 

[shreyans goyal]

If you want to multiply a series of numbers and they are present in range A1:C1 and you want to multiply it with a number say 2 then formula should be

=SUMPRODUCT(2*A1:C3)

Thanks for your reply. Actually I want each number under column A to be multiplied by number in column C. And then it should be added to next set. Means, A*C+A*C+A*C......... (here A and C means data in cells corresponding to the columns)

 

[Khalid NGO]

Thanks for your reply. Actually I want each number under column A to be multiplied by number in column C. And then it should be added to next set. Means, A*C+A*C+A*C......... (here A and C means data in cells corresponding to the columns)

Hi Shreyans,

Can you post your question in excel file with some data?
It will ease users to give you targeted solution.

Regards,

 

[KenU]

Assuming you are interested in the entirety of columns A and C, you can use:
=SUMPRODUCT(A:A,C:C)

Otherwise, you will need to alter the ranges to suit your requirements.

Hope that helps.

Regards,
Ken