Is there an easier way?

  • Thread starter Thread starter wmaughan
  • Start date Start date
Hi, try this array formula:

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

entered with SHIFT+CTRL+ENTER

HTH
JG
 
(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
pinmaster said:
Hi, try this array formula:

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

entered with SHIFT+CTRL+ENTER

HTH
JG
Click to expand...
Or without having to array enter:

=SUMPRODUCT(B12:E12*B17:E17)
 
Or use sumproduct as MS originally intended <bg>

=SUMPRODUCT(B12:E12,B17:E17)

--
Regards,

Peo Sjoblom

(No private emails please)
 
Peo Sjoblom said:
Or use sumproduct as MS originally intended <bg>

=SUMPRODUCT(B12:E12,B17:E17)
Click to expand...

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

--
Regards

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