I am currently building a data sheet using VLOOKUP. When there is no data to lookup it returns #N/A, which is fine. The problem is when I go to total these columns because of the NA it returns NA in the total box.
Having tried the if isna formula I am now returning #VALUE!.
I may be doing the IF ISNA formula wrong, anybody got any ideas?
Last edited by BankerSi; 01-06-2009 at 01:38 PM.
Try:
=SUMIF(E2:E7,"<>#N/A")
adjust range to suit.
or get rid of the N/A's by adding an error trap in the original Vlookup() formula.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Try:
=SUMIF(E2:E7,"<>#N/A")
adjust range to suit.
or get rid of the N/A's by adding an error trap in the original Vlookup() formula.
Great, that has worked as well!
Thanks, this has been a great help today.
One thing-I have done the SOLVED on my previous post as you requested but it is still showing on the forum as unsolved. Should I be worried about this or does it take time to update?
I just checked it that thread and I see it marked [Solved]. Not sure why you don't see it as suchOriginally Posted by BankerSi
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks