Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula not including a cell
I have created a chart to easily compare data between two years. I have
created many charts to coincide with the data I have stored but for some reason when I have it calculate ='2009 YTD Totals'!$B$18:$M$18 it is not including cell I18. Please help! I'm sure it is probably a simple solution and maybe my mind is just fried from staring at Excel all day. ;o) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula not including a cell
laudyhgp wrote:
I have created a chart to easily compare data between two years. I have created many charts to coincide with the data I have stored but for some reason when I have it calculate ='2009 YTD Totals'!$B$18:$M$18 it is not including cell I18. Please help! I'm sure it is probably a simple solution and maybe my mind is just fried from staring at Excel all day. ;o) Are you certain I18 is numeric? Test it with =ISNUMBER(I18). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I select numbers for a formula from a cell including text? | Excel Discussion (Misc queries) | |||
Insert row including formula | New Users to Excel | |||
Excel:Swap cell contents-including cell groups-betwen 2 locations | Excel Discussion (Misc queries) | |||
including current date in formula | Excel Worksheet Functions | |||
Formula including dates | Excel Worksheet Functions |