Remember Me?

#1
February 3rd 20, 12:09 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jun 2018 Posts: 24
Multiplying columsn and addin the results

In a spreadsheet I have numbers in the first row of each column from A to ?

The numbers has to be multiplied like this A1*B1, C1*D1, E1*F1 and so on. Finally the results have to be added.

Is possible in a single formula without entering all the single multiplications in a SUM(); something like =Sum(A1*B1:AX1*AY1)?

Jan

#2
February 4th 20, 11:05 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Dec 2015 Posts: 4
Multiplying columsn and addin the results

If last cell is AY1, i.e., last pair to multiply is AX1*AY1, as you wrote in your example, then try this formula:

=SUMPRODUCT(A1:AX1,B1:AY1,--(MOD(COLUMN(B1:AY1)-COLUMN(A1),2)=1))

For different range, adjust AX and AY accordingly.

On Monday, 3 February 2020 13:09:56 UTC+1, Daddy Sage wrote:
In a spreadsheet I have numbers in the first row of each column from A to ?

The numbers has to be multiplied like this A1*B1, C1*D1, E1*F1 and so on. Finally the results have to be added.

Is possible in a single formula without entering all the single multiplications in a SUM(); something like =Sum(A1*B1:AX1*AY1)?

Jan

#3
February 21st 20, 06:39 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jun 2018 Posts: 24
Multiplying columsn and addin the results

tirsdag den 4. februar 2020 kl. 12.05.46 UTC+1 skrev Vuko Strugar:
If last cell is AY1, i.e., last pair to multiply is AX1*AY1, as you wrote in your example, then try this formula:

=SUMPRODUCT(A1:AX1,B1:AY1,--(MOD(COLUMN(B1:AY1)-COLUMN(A1),2)=1))

For different range, adjust AX and AY accordingly.

On Monday, 3 February 2020 13:09:56 UTC+1, Daddy Sage wrote:
In a spreadsheet I have numbers in the first row of each column from A to ?

The numbers has to be multiplied like this A1*B1, C1*D1, E1*F1 and so on. Finally the results have to be added.

Is possible in a single formula without entering all the single multiplications in a SUM(); something like =Sum(A1*B1:AX1*AY1)?

Jan

Sorry! it took me so long to get back, but it works. Thank you.

Jan

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Dwipayan Das Excel Programming 0 April 17th 09 05:51 AM Gerry Excel Programming 0 October 31st 07 12:01 AM [email protected] Excel Programming 8 July 30th 07 03:30 AM Benjamin New Users to Excel 4 February 9th 07 07:10 AM Brandon Excel Programming 0 June 27th 06 11:18 PM

All times are GMT +1. The time now is 09:51 AM.