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