Mike,
Try ToolsOptionsView and see if Formulas in the Window Options section is
checked.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Michael Wright via OfficeKB.com" wrote in
message ...
=SUMIF(B1:B199,"business account",D1:D199)
The formula above returns the correct total - this is displayed in another
worksheet - the sheet the formula resides in displays the formula NOT the
result.
Any ideas, anyone?
Many thanks!
Regards,
Mike
--
Message posted via http://www.officekb.com