Formula is displayed, not result

  • Thread starter Thread starter Michael Wright via OfficeKB.com
  • Start date Start date
M

Michael Wright via OfficeKB.com

=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
 
Mike,

Try Tools>Options>View and see if Formulas in the Window Options section is
checked.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

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

E2007 formulas display as formulas, not results 3
formula displays as a formula, not as its result 1
Cell reference in formula string displays abbreviated value 2
vLookup returns formula and not result 4
Counting Results of Formulas 1
Lookup returning wrong results 0
Conditional formula with text 1
Formula results display only after pressing Enter key 1

Back
Top