Results 1 to 12 of 12

Excel 2007 : IF/AND TRUE/FALSE and two criteria

Threaded View

  1. #7
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,898

    Re: IF/AND TRUE/FALSE and two criteria

    Weird, if you reselect the range and go back to CF and click Ok, it is okay again... but if you close and re-open it disappears...

    Well try this one....

    =SUMPRODUCT((Name=$A2)*(LEFT(Decade,4)+0=FLOOR(YEAR($B2),10))*(Condition=TRUE))
    I saved and re-opened and it stuck this time.
    Attached Files Attached Files

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