Is there an easier way?

[wmaughan]

There has got to be an easier to accomplish the same end results as the
attached formula... any pointers?


+-------------------------------------------------------------------+
|Filename: Doc2.doc |
|Download: http://www.excelforum.com/attachment.php?postid=4133 |
+-------------------------------------------------------------------+

 

[pinmaster]

Hi, try this array formula:

=SUM((B12:E12)*(B17:E17))

entered with SHIFT+CTRL+ENTER

HTH
JG

 

[Sandy Mann]

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

Hi, try this array formula:

=SUM((B12:E12)*(B17:E17))

entered with SHIFT+CTRL+ENTER

HTH
JG

Or without having to array enter:

=SUMPRODUCT(B12:E12*B17:E17)

 

[wmaughan]

So simple, thanks, it worked

 

[Peo Sjoblom]

Or use sumproduct as MS originally intended <bg>

=SUMPRODUCT(B12:E12,B17:E17)

--
Regards,

Peo Sjoblom

(No private emails please)

 

[Sandy Mann]

Or use sumproduct as MS originally intended <bg>

=SUMPRODUCT(B12:E12,B17:E17)

Back to basics - now there's a real revelation! <vbg>

--
Regards

Sandy
(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk