Formula Result that Graphs like an Empty Cell?

[Cerestes]

If I graph a range of numbers, I get a nice continous graph.
If I delete one number in the middle of the range, my graph looks the same but with one 'missing' point (and the lines that connect it).

This is exactly what I want to do, but I'm not graphing hard numbers.
Everything in the range is the result of VLOOKUPs, and IF statements.

What I need is 'something' that the formulas can return that graphs exactly the same as an 'empty' cell.

Any ideas?

 

[eliW]

Hi
What do you want to be the result of the formula? is it 0 or "" ?
I suggest you to set the formula so that on this condition it will give =NA() this will ignore that point in the graph.
Eli

 

[Cerestes]

Ah! I think this is a partial solution.

Having the formula's return NA() makes my graphs correct.

The only issue I see know are two small sections where the results are averaged or summed.

Is there a simple formula to 'skip' cells that are "N/A"?
It needs to sum (or average) all cells in the range, but ignore N/A's.
Something like "=SUMIF(range,ISNA())"?