Results 1 to 4 of 4

Lookup Counting/Sum Formula

Threaded View

  1. #1
    Registered User
    Join Date
    10-06-2009
    Location
    Blackpool, UK
    MS-Off Ver
    Excel 2003
    Posts
    29

    Unhappy Lookup Counting/Sum Formula

    Hi,

    A B
    1 2
    1 3
    1 2
    2 3
    3 2
    1 2
    2 1

    Im trying to work out a formula that will look down Column A for the number 1 and then will count the number of times the number 2 appears on the same row as number 1 in Column B. The answer I should be getting is 3.
    Last edited by Sam_D; 10-06-2009 at 12:24 PM. Reason: Failed Rule 1!

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