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 !