Lambright44
New Member
- Joined
- Aug 3, 2010
- Messages
- 12
I have a large dataset and am trying to sum the results from a VLookup. Unfortunately, the results bring in the #N/A value. I can paste special to do away with the value but then I have to do that everytime as I loose my formulae.
I know there was a way to make the N/A value into a Zero by using the Custom Formating but its ben so long that I have forgotten that step and I'm sure there is an easier way.
Have tried SumIf with mixed results.
I know there was a way to make the N/A value into a Zero by using the Custom Formating but its ben so long that I have forgotten that step and I'm sure there is an easier way.
Have tried SumIf with mixed results.