+ Reply to Thread
Results 1 to 3 of 3

Combining multiple formulas

  1. #1
    Forum Contributor
    Join Date
    08-09-2006
    Posts
    147

    Red face Combining multiple formulas

    Can someone please help me. And, please don't laugh at my attempted formula below.

    What I am trying to do is:

    I have a database of all my monthly accounts. I want to be able to make sure that all accounts were reported for that month. I don't want to have to scroll through each account.

    I have set up a separate sheet with all accounts on it. So, now I want to

    find a value(WCW3936), if it finds this value and the date is 1/1/2006 then say ok,true,something. If not true then say no.

    Here is my attempted formuala. Of course, it doesn't work. But, maybe you can see what I'm trying to accomplish.

    =VLOOKUP("WCW3936",'Sheet2'!1:65536,12),if('Sheet2'!L:L="1/1/2006",OK,NO)

    If I need to explain further let me know. Thank you.
    Last edited by rlkerr; 11-30-2006 at 01:09 PM.

  2. #2
    Registered User
    Join Date
    12-08-2004
    Posts
    19
    One option would be to create an array to count how many times this occurs.

    {=SUM((Sheet2!A2:A15="WCW3936")*(Sheet2!B2:B15=DATE(2006,1,1)))}

  3. #3
    Forum Contributor
    Join Date
    08-09-2006
    Posts
    147
    It keeps returning the value 0. And, there is a date of 1/1/2006.

+ Reply to Thread

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