sumproduct value error
 

=SUMPRODUCT(--($AI$2:$AI$400=$AM$4),--($E$2:$E$400="TWINSTATIA"),$X$2:$X$400)
returns a value error.

AI2:AI400 is a column with the month billed (i.e. Jan, Feb, March, etc...)
AM4 is the word "Dec" (the only month I want to include in the sum product)
E2:E400 is a column with the customer name (in this case, I want to only
total those with TWINSTATIA)
X2:X400 is a column with the total pay (each cell has a formula)

Any suggestions? This same formula works for previous months. I have
rechecked to make sure the month is spelled right & the right cells are
referenced.

Thank you.

sumproduct value error
 

You may?? have leading/trailing spaces. Try incorporating TRIM into your
formula.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"quinn111" wrote in message
...
=SUMPRODUCT(--($AI$2:$AI$400=$AM$4),--($E$2:$E$400="TWINSTATIA"),$X$2:$X$400)
returns a value error.

AI2:AI400 is a column with the month billed (i.e. Jan, Feb, March, etc...)
AM4 is the word "Dec" (the only month I want to include in the sum
product)
E2:E400 is a column with the customer name (in this case, I want to only
total those with TWINSTATIA)
X2:X400 is a column with the total pay (each cell has a formula)

Any suggestions? This same formula works for previous months. I have
rechecked to make sure the month is spelled right & the right cells are
referenced.

Thank you.

sumproduct value error
 

Thanks Don. I figured it out. I did had $X$401 instead of $X$400. I knew t
hey had to be the same size range. Thank you for responding.

"Don Guillett" wrote:

You may?? have leading/trailing spaces. Try incorporating TRIM into your
formula.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"quinn111" wrote in message
...
=SUMPRODUCT(--($AI$2:$AI$400=$AM$4),--($E$2:$E$400="TWINSTATIA"),$X$2:$X$400)
returns a value error.

AI2:AI400 is a column with the month billed (i.e. Jan, Feb, March, etc...)
AM4 is the word "Dec" (the only month I want to include in the sum
product)
E2:E400 is a column with the customer name (in this case, I want to only
total those with TWINSTATIA)
X2:X400 is a column with the total pay (each cell has a formula)

Any suggestions? This same formula works for previous months. I have
rechecked to make sure the month is spelled right & the right cells are
referenced.

Thank you.

sumproduct value error
 

If you are getting a #VALUE error, that implies that your data in
column X is not made up of numeric values, so I would check those out.
You may have values which look like numbers, but are actually text
values, or you might have "" in some cells if a conditional formula is
used in column X.

Hope this helps.

Pete

On Jan 22, 11:08*pm, quinn111
wrote:
=SUMPRODUCT(--($AI$2:$AI$400=$AM$4),--($E$2:$E$400="TWINSTATIA"),$X$2:$X$40*0)
*returns a value error.

AI2:AI400 is a column with the month billed (i.e. Jan, Feb, March, etc...)
AM4 is the word "Dec" (the only month I want to include in the sum product)
E2:E400 is a column with the customer name (in this case, I want to only
total those with TWINSTATIA)
X2:X400 is a column with the total pay (each cell has a formula)

Any suggestions? *This same formula works for previous months. *I have
rechecked to make sure the month is spelled right & the right cells are
referenced.

Thank you.

sumproduct value error
 

With that syntax:

=SUMPRODUCT(--(test1),--(test2),C1:C10)

TEXT is ignored in the C1:C10 array.

This syntax will return the #VALUE! error:

=SUMPRODUCT((test1)*(test2)*C1:C10)

--
Biff
Microsoft Excel MVP


"Pete_UK" wrote in message
...
If you are getting a #VALUE error, that implies that your data in
column X is not made up of numeric values, so I would check those out.
You may have values which look like numbers, but are actually text
values, or you might have "" in some cells if a conditional formula is
used in column X.

Hope this helps.

Pete

On Jan 22, 11:08 pm, quinn111
wrote:
=SUMPRODUCT(--($AI$2:$AI$400=$AM$4),--($E$2:$E$400="TWINSTATIA"),$X$2:$X$40*0)
returns a value error.

AI2:AI400 is a column with the month billed (i.e. Jan, Feb, March, etc...)
AM4 is the word "Dec" (the only month I want to include in the sum
product)
E2:E400 is a column with the customer name (in this case, I want to only
total those with TWINSTATIA)
X2:X400 is a column with the total pay (each cell has a formula)

Any suggestions? This same formula works for previous months. I have
rechecked to make sure the month is spelled right & the right cells are
referenced.

Thank you.