Sumproduct() does not allow you to use full column references like A:A, or named ranges referring to full columns....Sumif() does allow it.