#NAME? error on Sumif

[RaeColclough]

Hi, I have an issue with a colleague of mine. I have created a report for her which works fine on my laptop (Windows 10), and also my other colleagues laptop (also windows 10) however when I send it to her (Windows 7) she gets a #name? error in some of the SUMIF fields, however a majority of them work fine and it is a random selection throughout the report which doesn't work.
Has anyone come across this before as I'm not sure how to resolve it?

 

[jasonb75]

#NAME? means that either a function or a named range doesn't exist. If you have used other functions with the SUMIF formula and your colleague is using an older version of excel then it could mean that one of the functions is not supported in their version.

This might not necessarily be part of the SUMIF formula, it could be in a cell that the formula refers to.