Or use sumproduct as MS originally intended <bg

=SUMPRODUCT(B12:E12,B17:E17)

--
Regards,

Peo Sjoblom

(No private emails please)


"Sandy Mann" wrote in message
...


with @tiscali.co.uk
"pinmaster" wrote
in message ...

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