Why Am I getting a blank in the result cell?
 

Can someone assist me with what I'm doing wrong with the formula below?
It keeps returning a blank in the resulting cell. I am trying to
calculate the weighted avg. of production scores for an employee based
on hours worked per month. columns B,D,F,H,J, and L are the hours while
C,E,G,I,K, and M are the prod scores. Manual calculation should result
in a 90.9% weighted averge.

B C D E F G H I J K
L M wgtd. Avg.
129 117 - - 29 75 19 32 - - 50
55 90.9%

=IF(ISERROR(SUMPRODUCT((B13*C13)+(D13*E13)+(F13*G1 3)+(H13*I13)+(J13*K13)+(L13*M13))/(B13+D13+F13+H13+J13+L13)),"",SUMPRODUCT((B13*C13) +(D13*E13)+(F13*G13)+(H13*I13)+(J13*K13)+(L13*M13) )/(B13+D13+F13+H13+J13+L13))

Note: Columns D,E and J,K are blanks. Also, the data above are linked
from other worksheets with "IF" statements.

Whoever can solve this would be be my HERO ........


--
salulu
------------------------------------------------------------------------
salulu's Profile: http://www.excelforum.com/member.php...o&userid=27042
View this thread: http://www.excelforum.com/showthread...hreadid=461767

I tried the formula and it seems to work alright for me. My hunch is
that in D,E,J or K you have a space instead of a blank. To be safe -
if you type a zero in each of these 4 cells that are supposed to be
blank, your formula should return 90.9% Let me know if this doesn't
work - Chad


--
cvolkert
------------------------------------------------------------------------
cvolkert's Profile: http://www.excelforum.com/member.php...o&userid=24380
View this thread: http://www.excelforum.com/showthread...hreadid=461767

it sounds like you have text in some of the cells in the denominator
which results in the error default


--
duane


------------------------------------------------------------------------
duane's Profile: http://www.excelforum.com/member.php...o&userid=11624
View this thread: http://www.excelforum.com/showthread...hreadid=461767

I tried the formula and it seems to work alright for me. My hunch is
that in D,E,J or K you have a space instead of a blank. To be safe -
if you type a zero in each of these 4 cells that are supposed to be
blank, your formula should return 90.9% Let me know if this doesn't
work - Chad


--
cvolkert
------------------------------------------------------------------------
cvolkert's Profile: http://www.excelforum.com/member.php...o&userid=24380
View this thread: http://www.excelforum.com/showthread...hreadid=461767

Thanx to both chad and duane. I solved the problem. I took part of
chad's advise by replacing the " " in my IF statement with "0s" in the
linked data cells, and whoola, it worked. You guys are my hero
.............


--
salulu
------------------------------------------------------------------------
salulu's Profile: http://www.excelforum.com/member.php...o&userid=27042
View this thread: http://www.excelforum.com/showthread...hreadid=461767