Dear Sir, I want to do a sum-up for column A1:A5 whose values are larger than 1. To ignore error cells, I used the array as:
=SUM(IF(ISNUMBER(A1:A5),IF(A1:A5>1,A1:A5,""),"")).
My question is: Is there a more 'clever' way to ignore errors? I feel the above formula does not look very neat.
1
#N/A
2
#DIV/0!
4
Bookmarks