It looks like you're new here. If you want to get involved, click one of these buttons!
I use SUMIF a lot to keep an eye on stock in external warehouses. The supplier sends me a worksheet with stock sorted by code. I have the same code in a master sheet and with one particular supplier SUMIF doesn't work unless I retype the code over their code, or copy and paste special values from my code list to theirs.
I realise this is probably due to the formatting of the external worksheet, but I can't change that. Does anyone know how to get my sheet to read their sheet without retyping?