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.How can I revised the above said formula so that perfect match can be done which is currently is due to spaces.![]()
=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)
Thanking you in anticipation.
Bookmarks