Results 1 to 9 of 9

Adding condition to existing formula

Threaded View

  1. #1
    Registered User
    Join Date
    10-05-2009
    Location
    Florida
    MS-Off Ver
    Excel 2007
    Posts
    76

    Adding condition to existing formula

    I have an existing formula that I am using, however, I need to add another condition to it but am unsure on where to add into the formula to make it work correctly. Any help would be greatly appreciated.

    I need to add (NEW!$H2:$H65000="MBA.ACC")

    to

    =SUM(IF(FREQUENCY(IF(LEN(NEW!$C$2:$C$65000)>0,MATCH(NEW!$C$2:$C$65000,NEW!$C$2:$C$65000,0),""), IF(LEN(NEW!$C$2:$C$65000)>0,MATCH(NEW!$C$2:$C$65000,NEW!$C$2:$C$65000,0),""))>0,1))

    Thanks in advance.
    Last edited by KINNEY0201; 09-16-2010 at 02:01 PM.

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