Hi,

I am facing a problem with the matching that is not producing the desired results.It might be due to the spaces in left hand side of each.The below formula I am using. 
=SUMIFS(DO!$Y$2:$Y$431,DO!$A$2:$A$431,SO!B2,DO!$T$2:$T$431,SO!A2,DO!$V$2:$V$431,SO!V2,DO!$X$2:$X$431,SO!AJ2)
How can I revised the above said formula so that perfect match can be done which is currently is due to spaces.

Thanking you in anticipation.