Formula not including a cell

L

laudyhgp

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)
 
S

smartin

laudyhgp said:
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)
Click to expand...

Are you certain I18 is numeric? Test it with =ISNUMBER(I18).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop Down List Dependant Formula 2
Copy addition formula of non-consecutive horizontal cells 2
First row where a cell is zero 2
YTD SUMIF based on current date 3
VBA word change keys 0
Define a Range based on Cell Values 2
Spurious Formula Omits Adjacent Cells 2
Pls Help - blank cell/formula issue 7

Top