Case Sensitive SumProduct
 

I am using this formula:

=(SUMPRODUCT(--($E$48:$E$22962=226);--($J$48:$J$22962=$W19);--($G$48:$G$22962="SailDirectedOrderNotice");$A$48:$ A$22962))

The value in $W19 is 'gd'. in the column of data, there is also 'GD'. The formaul is calculating the 'GD' data, not 'gd'.

Is there a way to make the formula case sensitive ?

Thanks in advance.

Case Sensitive SumProduct
 

Hi,

You could try the EXACT formula:

EXACT($J$48:$J$22962,$W19)

in place of

($J$48:$J$22962=$W19)

Case Sensitive SumProduct
 

On Monday, November 26, 2012 12:07:56 PM UTC-5, wrote:
I am using this formula: =(SUMPRODUCT(--($E$48:$E$22962=226);--($J$48:$J$22962=$W19);--($G$48:$G$22962="SailDirectedOrderNotice");$A$48:$ A$22962)) The value in $W19 is 'gd'. in the column of data, there is also 'GD'.. The formaul is calculating the 'GD' data, not 'gd'. Is there a way to make the formula case sensitive ? Thanks in advance.

Thanks.

I tried this:

=(SUMPRODUCT(--($E$48:$E$22962=226);--EXACT($J$48:$J$22962=$W19);--($G$48:$G$22962="SailDirectedOrderNotice");$A$48:$ A$22962))

but excel returned an error "...entered too few arguments for this function...."

Case Sensitive SumProduct
 

On Mon, 26 Nov 2012 12:30:27 -0800 (PST), wrote:

On Monday, November 26, 2012 12:07:56 PM UTC-5, wrote:
I am using this formula: =(SUMPRODUCT(--($E$48:$E$22962=226);--($J$48:$J$22962=$W19);--($G$48:$G$22962="SailDirectedOrderNotice");$A$48:$ A$22962)) The value in $W19 is 'gd'. in the column of data, there is also 'GD'. The formaul is calculating the 'GD' data, not 'gd'. Is there a way to make the formula case sensitive ? Thanks in advance.

Thanks.

I tried this:

=(SUMPRODUCT(--($E$48:$E$22962=226);--EXACT($J$48:$J$22962=$W19);--($G$48:$G$22962="SailDirectedOrderNotice");$A$48:$ A$22962))

but excel returned an error "...entered too few arguments for this function..."

Perhaps if you tried the syntax that Ben suggested ...

--EXACT($J$48:$J$22962,$W19)

Case Sensitive SumProduct
 

On Monday, November 26, 2012 12:07:56 PM UTC-5, wrote:
I am using this formula: =(SUMPRODUCT(--($E$48:$E$22962=226);--($J$48:$J$22962=$W19);--($G$48:$G$22962="SailDirectedOrderNotice");$A$48:$ A$22962)) The value in $W19 is 'gd'. in the column of data, there is also 'GD'.. The formaul is calculating the 'GD' data, not 'gd'. Is there a way to make the formula case sensitive ? Thanks in advance.

Thank you all. I've got it working !