Hi, I have two related questions.

First, I would like to do a sum function but with cells that are not next to each other and may sometimes be #N/A. See below:

=SUMIF((A1,C1,E1),"<>#N/A")

Unfortunately this only seems to work if the range is continuous, such as when it is (A1:E1). Any suggestions?

Second, I'm doing something similar but with an vlookup array. See below:

{=SUMIF(VLOOKUP($A$1,A1:AZ8,{5,14,23,32},FALSE),"<>#N/A"}

This also doesn't work. Any recommendations?

Thank you!