In article ,
"Matt" wrote:

Guys, what would cause me to get a #Num error when doing this function??

This is getting irritating!!!

You'll get that error if you're using whole column references.
SUMPRODUCT doesn't accept them. You could change the reference to a
'near' whole column reference, such as B2:B65536.

Hope this helps!