G
Guest
I have a hllookup formula that provides certain results as #N/A....I
understand why I get a #N/A, however, I need to subtotal the row. I tried to
use the subtotal formula, but it does not recognize #N/A as a number,
obviously cause it is not a number. I need to add these up for example:
10, 20, #N/A, #N/A, Subtotal: 30
How can I convert the #N/A so that they are "0" or blank so that my formula
works?
Thanks!
understand why I get a #N/A, however, I need to subtotal the row. I tried to
use the subtotal formula, but it does not recognize #N/A as a number,
obviously cause it is not a number. I need to add these up for example:
10, 20, #N/A, #N/A, Subtotal: 30
How can I convert the #N/A so that they are "0" or blank so that my formula
works?
Thanks!