Results 1 to 1 of 1

Value noshow in cell, no errors either

Threaded View

  1. #1
    Registered User
    Join Date
    03-04-2009
    Location
    PA, USA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Value noshow in cell, no errors either

    =SUM(IF('Ledger 2009'!I3:I918>=7,IF('Ledger 2009'!I3:I918<=21,IF('Ledger 2009'!G3:G918="FO",'Ledger 2009'!D3:D918,0),0),0))

    all cells formatted correctly
    The function Arguments box shows the correct return value
    no error appears
    However, the formula results do not display in the cell.

    Hmm, no errors, no return

    when i test it with simple formula such s
    =SUM('Ledger 2009'!D3:D918)
    or
    =SUMIF('Ledger 2009'!I3:I7,"=2",'Ledger 2009'!D3:D7)

    a value shows in the cell.

    Any Idea? Help

    Uncle Keith

    !! OOPS forgot to Shift Ctrl Enter! figured it out, but thanks!
    Last edited by VBA Noob; 03-18-2009 at 06:15 PM. Reason: Realized My Error

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1