Hi,
I am trying to count the total quantity by item name (note, the criteria is dynamic, not able to fix it as text using " "), how should this be done?
Looks quite straight forward, but somehow I have tried various ways of copy and paste differently, have tried changing the cell format... but to no avail.
Can please help.
Thank you.
Bookmarks