Round down a weighted average

[Teatro]

I am working with a spreadsheet that calculates weighted
averages for items. The weighted averages formula works
just fine; however, Excel keeps rounding up to the nearest
number, and I can't get it to round down to accurately
reflect the actual weighted average.

Here is my formula without the ROUNDDOWN function:
=SUMPRODUCT(B19:F19,$B$17:$F$17)/SUM(B19:F19)

B19:F19 = number of responses
$B$17:$F$17 = value of response

I want it to round down to 1 decimal point, so I know I
need to add ROUNDDOWN at the beginning of the formula and
then specify the number of digits at the end, but I can't
get it to work without the errors of missing parenthesis,
too few arguments, etc. Can this be done?

Thanks in advance.

 

[Bob Phillips]

=ROUNDDOWN(SUMPRODUCT(B19:F19,$B$17:$F$17)/SUM(B19:F19),1)

 

[Guest]

Thank you! Worked like a charm. I was (as usual) trying to
over-complicate the formula.