Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to .. | Excel Discussion (Misc queries) | |||
Replace null string with blank cell | Excel Discussion (Misc queries) | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |