I have a row with one value of BO11 and 4 values of #N/A.
How can I make a new column and sum the first 5 rows to result in only the one with a non-N/A value?
I have a row with one value of BO11 and 4 values of #N/A.
How can I make a new column and sum the first 5 rows to result in only the one with a non-N/A value?
figured it out =LOOKUP("zzzzzzzzz",I19:Y19)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks