| View previous topic :: View next topic |
| Author |
Message |
__fastcall
Newbie
Joined: 25 Jul 2009
Posts: 2
|
 Posted: Sat Jul 25, 2009 11:51 am Post subject: =SUM( A1:A10 * B1:B10 ) ? |
 |
|
Is there a formula to calculate the sum of the products of each row in two columns?
e.g:
| Code: | | =SUM( A1:$A10 * B1:$B10 ) |
The problem is easily fixed by using: =SUM( A1*B1; A2*B2; A3*B3; A4*B4; ... )
Unfortunately it's not what I'm looking for...
Any suggestions? |
|
| Back to top |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
|
| Back to top |
|
|
hotpepper
Power User
Joined: 04 Dec 2008
Posts: 52
|
| Posted: Sat Jul 25, 2009 1:14 pm Post subject: |
|
|
What you want is SUMPRODUCT:
=SUMPRODUCT(A1:A10;B1:B10) |
|
| Back to top |
|
|
__fastcall
Newbie
Joined: 25 Jul 2009
Posts: 2
|
| Posted: Sat Jul 25, 2009 2:22 pm Post subject: |
|
|
Villeroy:
Yeah, that's what I'm currently using.
hotpepper:
Thanks, that's what I'm looking for at the moment. |
|
| Back to top |
|
|
|
