Getting #DIV/0! error in excel

[MetroTech Support]

I'm getting the #DIV/0! error in excel. I understand that it is because the
cell I am calculating on is blank, and that I need to use the "IF" statement.
However, my calculation is a long, complicated one and I can't figure out
where to put the "IF". (see below)
Help!

=((F29*$F$26)+(G29*$G$26)+(H29*$H$26)+(I29*$I$26)+(J29*$J$26)+(K29*$K$26)+(L29*$L$26))/((SUM(F29:L29)))


(It is calculating the average of daily sales at different $ rates per
transaction, and I need to sum 5 of them per sales person)

 

[Jim Thomlinson]

=if(SUM(F29:L29) = 0, 0,
((F29*$F$26)+(G29*$G$26)+(H29*$H$26)+(I29*$I$26)+(J29*$J$26)+(K29*$K$26)+(L29*$L$26))/((SUM(F29:L29))))

or since most of your brackets are unnecessary

=if(SUM(F29:L29) = 0, 0,
(F29*$F$26+G29*$G$26+H29*$H$26+I29*$I$26+J29*$J$26+K29*$K$26+L29*$L$26)/SUM(F29:L29))

 

[Peo Sjoblom]

Try


=IF(SUM(F29:L29)=0,0,SUMPRODUCT(F26:L26,F29:L29)/SUM(F29:L29))

--


Regards,


Peo Sjoblom

 

[T. Valko]

Try this:

=IF(SUM(F29:L29),SUMPRODUCT($F$26:$L$26,F29:L29)/SUM(F29:L29),"")