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.

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[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.

This worked. Thank you.

Hi, I'm getting a #VALUE! error in the cell when I entered a ? in one of the cells A3:AG3 cells using the SUM(MMULT(--WRAPROWS(A3:AG3,3),TOCOL(A1:C1))) formula. Any workaround that will not count that cell and sum all the others that have numbers? I would like to use a ? or X as well. Thanks.

 

[Fluff]

How about

=SUM(MMULT((IFERROR(WRAPROWS(A3:AG3,3)+0,0)),TOCOL(A1:C1)))

 

[tmk0427]

=SUM(MMULT((IFERROR(WRAPROWS(A3:AG3,3)+0,0)),TOCOL(A1:C1)))

That works. Thanks.

 

[Fluff]

You're welcome.