Results 1 to 6 of 6

Need formula to count multiple criteria in 2 columns

Threaded View

  1. #1
    Registered User
    Join Date
    08-08-2011
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    21

    Need formula to count multiple criteria in 2 columns

    Hi,
    I have a set of data in column A and B. I need a formula to count the occurances of given cell contents in column 1 and in column 2.
    For example
    Column A Column B
    1c 1a
    p6 p7
    p5 p6
    p4 p8
    1b 1a
    P5 1c
    2c 2b

    I would like the formula to count all of the occurances of P4, P5, P6 in column A and those that are still P4, P5, P6 in column B. In the case of the data above the number returned will be 3 as the P5 second bottom is not a P number in Column B. Hope that makes sense!

    Any help would be gratefully received.
    Thanks
    Last edited by tancho321; 01-22-2013 at 04:51 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