sumproduct syntax
 

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

sumproduct syntax
 

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

sumproduct syntax
 

Thanks, Don, It worked great. I knew I was missing something simple

"Don Guillett" wrote:

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

sumproduct syntax
 

glad to help

--
Don Guillett
SalesAid Software

"Mitchell" wrote in message
...
Thanks, Don, It worked great. I knew I was missing something simple

"Don Guillett" wrote:

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