[Resolved]Excel Index Function

[Bartender]

In addition to the other issue I'm have with ranges in the worksheet function Index that I posted in the thread "Excel Ranges," I have run into another problem which I can't figure out how to work around. I have to use an index on a block of cells, say B2:AL38, which has some numbers scattered in it, but a lot of blank cells as well.
The blank cells must remain blank.
When i use :
Application.Index([Sheet1!B2:AL38], row, col)
and it sees a blank cell, it gives me an object mismatch--- since it finds a string and wants a value---I think, at least. How can I make it think "zero" when it sees a blank cell?
How could I just do a :
If Application.Index(Inputs)='object mismatch' Then
Var=Var+0
Else
Var=Var+Application.Index(Inputs)
End If
?
How would I really write that?
Sigh.

Thanks for your help!