Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel function troubles
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel function troubles
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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel function troubles
Hi
if you open your workbook on another computer do you have the same problem? if you create a new workbook with just a value in N2 & N3 and try the subtotal function does it work? Cheers JulieD "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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Formula troubles | Excel Worksheet Functions | |||
Excel troubles | Excel Worksheet Functions | |||
Troubles with the OFFSET function | Excel Worksheet Functions | |||
Excel Troubles | Excel Programming | |||
saving *.xls files but troubles with opening with MS Excel | Excel Programming |