Case Sensitive SumProduct

  • Thread starter Thread starter cmiedaner
  • Start date Start date
C

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.
 
Hi,

You could try the EXACT formula:

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

in place of

($J$48:$J$22962=$W19)
 
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.
Click to expand...

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...."
 
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.
Click to expand...

Thank you all. I've got it working !
 
Back
Top