NigelPatrick
New Member
- Joined
- Dec 8, 2023
- Messages
- 6
- Office Version
- 2021
- Platform
- Windows
Hi all.
I have a function as follows =(SUM(J64:N64)+LARGE(H64:I64,1))
That returns a #NUM! error because H64 and I64 both contain a value of 0 (Zero). However Zero is a valid value so how do I change this formula to return the sum of J64:N64 plus Zero?
Thanks in advance
I have a function as follows =(SUM(J64:N64)+LARGE(H64:I64,1))
That returns a #NUM! error because H64 and I64 both contain a value of 0 (Zero). However Zero is a valid value so how do I change this formula to return the sum of J64:N64 plus Zero?
Thanks in advance