sumproduct formula help

[tmk0427]

Hi, I'm trying to find a simple formula that will sum all of the cells in this row where cell F2=A2*$A$1+B2*$B$1+C2*$C$1+D2*$A$1+E2*$B$1. I want to duplicate that formula for multiple rows so I can sum the total of that summed column. Hope that makes sense. Thanks.

 

[tmk0427]

I forgot to mention that in this example only A1, B1 and C1 have fixed data in it and the second row has different numbers but only those cells with numbers greater than zero or blank will be summed

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

I think a small set of sample dummy data and the expected results would also help. Provide any further clarification that you can in relation to the sample data.
MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[kweaver]

Is there more you're not sharing? Otherwise, why not do this:

=SUM(A1:C1*(A3:C3+D3:F3))

 

[tmk0427]

The third row runs all the way to AG3. Anything a little more easier to use to cover a lot of cells same pattern?

 

[tmk0427]

Also, there about 47 columns same as row 3

 

[Fluff]

How about

=SUM(MMULT(--WRAPROWS(A3:AG3,3),TOCOL(A1:C1)))

 

[Peter_SSs]

Does this do what you want?

23 05 26.xlsm
	A	B	C	D	E	F	G
1	10	10	10
2	1	2	3	1	2	3
3	1	1	1	1	1	1	60
SP

Cell Formulas
Range	Formula
G3	G3	=SUMPRODUCT(INDEX(A1:C1,A2:F2),FILTER(A3:F3,A2:F2=A2:F2))

 

[Fluff]

@tmk0427
In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.
On this occasion I have merged both threads.

 

[tmk0427]

How about

=SUM(MMULT(--WRAPROWS(A3:AG3,3),TOCOL(A1:C1)))

This worked. Thank you.