Hello all,
Please in the attached file, I want to use trim function to remove excess space in "Emmanuel" and then add all the "33" bought by customer Emmanuel. The trim function works very well for Sumproduct but not working for Sumif. How do I make it work for Sumif?
Thanks.
Bookmarks