Recently my version of Excel has gone nuts as it will not allow me to do simple forulmas such as sumif or countif.
For example, when creating a countif forumula, the default structure would be something along the lines of COUNTIF(range, criteria). However for some reason when following this structure I receive error messages.
While typing the forumlas in Excel, the formula prompt shows the formula structure as being COUNTIF(range criteria) - i.e the "," is missing between the fields.
I've tried to perform a detect & repair but without any luck. Does anyone out there now how to fix this problem? How can I get Excel to recognise "," again in the forumulas?
Thanks
For example, when creating a countif forumula, the default structure would be something along the lines of COUNTIF(range, criteria). However for some reason when following this structure I receive error messages.
While typing the forumlas in Excel, the formula prompt shows the formula structure as being COUNTIF(range criteria) - i.e the "," is missing between the fields.
I've tried to perform a detect & repair but without any luck. Does anyone out there now how to fix this problem? How can I get Excel to recognise "," again in the forumulas?
Thanks