Is there an easier way?

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

Hi, try this array formula:

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

entered with SHIFT+CTRL+ENTER

HTH
JG

[email protected]
[email protected] with @tiscali.co.uk
"pinmaster" <[email protected]> wrote
in message news:[email protected]...
>
> Hi, try this array formula:
>
> =SUM((B12:E12)*(B17:E17))
>
> entered with SHIFT+CTRL+ENTER
>
> HTH
> JG
>
>
> --
> pinmaster
> ------------------------------------------------------------------------
> pinmaster's Profile:
> http://www.excelforum.com/member.php...fo&userid=6261
> View this thread: http://www.excelforum.com/showthread...hreadid=494743
>
Or without having to array enter:

=SUMPRODUCT(B12:E12*B17:E17)
--
HTH

Sandy

So simple, thanks, it worked!

Or use sumproduct as MS originally intended <bg>

=SUMPRODUCT(B12:E12,B17:E17)

--
Regards,

Peo Sjoblom

(No private emails please)


"Sandy Mann" <[email protected]> wrote in message
news:[email protected]...
>
> [email protected]
> [email protected] with @tiscali.co.uk
> "pinmaster" <[email protected]> wrote
> in message news:[email protected]...
>>
>> Hi, try this array formula:
>>
>> =SUM((B12:E12)*(B17:E17))
>>
>> entered with SHIFT+CTRL+ENTER
>>
>> HTH
>> JG
>>
>>
>> --
>> pinmaster
>> ------------------------------------------------------------------------
>> pinmaster's Profile:
>> http://www.excelforum.com/member.php...fo&userid=6261
>> View this thread:
>> http://www.excelforum.com/showthread...hreadid=494743
>>
> Or without having to array enter:
>
> =SUMPRODUCT(B12:E12*B17:E17)
> --
> HTH
>
> Sandy
>

"Peo Sjoblom" <[email protected]> wrote in message
news:%[email protected]...
> 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
[email protected]
[email protected] with @tiscali.co.uk