Case Sensitive SumProduct

[cmiedaner]

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.

 

[Ben McClave]

Hi,

You could try the EXACT formula:

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

in place of

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

 

[cmiedaner]

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...."

 

[Ron Rosenfeld]

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)

 

[cmiedaner]

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 !