Gino,

Sounds like your entries are being entered as text. Try formatting the
cells N2 and N3 for numbers, and then re-entering the numbers into N2 and
N3.

The SUBTOTAL function ignores text, while the formula =N2+N3 coerces the
values from text to numbers.

HTH,
Bernie
MS Excel MVP

"ginovcaponi" wrote in message
...
I am having difficulties using the Sub-Total and VLookup functions in
Excel.
There may be other function troubles that I'm unaware of, but these are
the
ones I'm aware of. I've had several people look at my sub-total problem,
and
no one can figure what the problem is. For example, in an attachment that
I
can send, I used the auto sub-total for a tab in a workbook. The cell
entry
is =SUBTOTAL(9,N2:N3). The answer it gives me is 0. When I type in
=N2+N3,
the answer is 5. Can anyone help?