There has got to be an easier to accomplish the same end results as the attached formula... any pointers?
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks