|You will probably also have to modify your formula to use the SUM function, |
which ignores Text Characters.
Something like this should work
See here for more info on the #VALUE error
This should also work:
message edited by mmcconaghy