After a bit of searching I found some guidance of the use of the SUMPRODUCT function at http://www.meadinkent.co.uk/xlsumproduct.htm and used the formula

=SUMPRODUCT(($B$14:$O$14)*(B19:O19))

It worked a treat. Thanks to any one who was thinking of helping out!