About Us

Don Guillett

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sumproduct syntax question	ocuhcs	Excel Worksheet Functions	6	May 22nd 09 06:58 PM
SUMPRODUCT use of --() syntax	Stephen Lloyd[_2_]	Excel Worksheet Functions	2	June 27th 08 09:26 PM
Sumproduct syntax when using AND, OR	adimar	Excel Worksheet Functions	3	February 6th 08 10:04 PM
Sumproduct syntax - more complex	Mitchell	Excel Discussion (Misc queries)	4	November 9th 06 07:46 PM
WorksheetFunction.Sumproduct(syntax...	David	Excel Programming	9	November 1st 04 09:01 PM