I am trying to use sum product and I have tried this several ways. The most
recent is =SUMPRODUCT(--('Buy Tool'!K:K="Heather"),--('Buy
Tool'!L:L="b"),('Buy Tool'!AR:AR)). I am trying to sum the amounts in AR:AR
where the both of these critieria are met. I get a #num error. What am I
doing wrong?