T
Todd
I need to sum a column if numbers that contains many #n/a returns. I was
thinking of the sumproduct formula but I can't figure out how to get it to
ignore the n/a's.
something like SUMPRODUCT(--(ISNUMBER(F3:F610)),F3:F610)
How do I do this?
Thanks
thinking of the sumproduct formula but I can't figure out how to get it to
ignore the n/a's.
something like SUMPRODUCT(--(ISNUMBER(F3:F610)),F3:F610)
How do I do this?
Thanks