Sorry, just the cut and paste from the post made the extra rows, it work now!

THANKS!

Lisa

"Lisa" wrote:

One more prablem, it is still taking up 2 rows, so the formala is taking B1
and B2, not just B1.

Lisa

"Mikeopolo" wrote:


If you press F9 does the result change?

If so, your calculation was set to manual - change to automatic (tools,
Options, Calculation, and set to auto.

Regards
Mike


--
Mikeopolo
------------------------------------------------------------------------
Mikeopolo's Profile: http://www.excelforum.com/member.php...o&userid=18570
View this thread: http://www.excelforum.com/showthread...hreadid=571352