sumproduct does NOT take whole columns. You must use equal ranges
a1:a100 b2:b101

--
Don Guillett
SalesAid Software

"Mitchell" wrote in message
...
I am having a syntax problem with sumproduct. I have a column with names, I
have a column with numbers and the word cut and a 3rd column of numbers.
I want to add the numbers where in the 3rd column where the names are a
match and the word cut does not appear in the row.
=SUMPRODUCT(--(Tasks!CI:CI="stao"),--(Tasks!H:H<"CUT"), Tasks!CG:CG)
Thanks for the help