sumproduct ignoring errors

[rayk8301]

Hello,

I have been having some issues getting sumproduct to work and ignores errors and only focus on numbered cells. Example is I'm trying to get the weighted average of average handle times against the number of calls taken per person. Example sumproduct is = sumproduct(handle times, # of calls)/sum(# of calls))

any help is appreciated!

 

[Marcelo Branco]

Re: sumproduct ignorning errors

Sorry, i've reversed the columns

Maybe

[Table="class: grid"][tr][td="bgcolor: #DCE6F1"][/td][td="bgcolor: #DCE6F1"]

J​

[/td][td="bgcolor: #DCE6F1"]

K​

[/td][td="bgcolor: #DCE6F1"]

L​

[/td][/tr]
[tr][td="bgcolor: #DCE6F1"]

1​

[/td][td]

Weight​

[/td][td]

Values​

[/td][td]

Result​

[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

2​

[/td][td]

1​

[/td][td]

10​

[/td][td]

16,85714​

[/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

3​

[/td][td]

#NOME?​

[/td][td]

12​

[/td][td][/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

4​

[/td][td]

3​

[/td][td]

14​

[/td][td][/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

5​

[/td][td]

4​

[/td][td]

16​

[/td][td][/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

6​

[/td][td]

#NOME?​

[/td][td]

18​

[/td][td][/td][/tr]

[tr][td="bgcolor: #DCE6F1"]

7​

[/td][td]

6​

[/td][td]

20​

[/td][td][/td][/tr]
[/table]

Array formula in L2
=SUM(IF(ISNUMBER(J2:J7),J2:J7*K2:K7))/SUM(IF(ISNUMBER(J2:J7),J2:J7))
confirmed with Ctrl+Shift+Enter, not just enter

M.