Results 1 to 3 of 3

COUNTIF Multiple Column Criteria

Threaded View

  1. #1
    Registered User
    Join Date
    07-09-2012
    Location
    Honolulu, HI
    MS-Off Ver
    Excel for Mac 2011 version 14.0.0
    Posts
    3

    COUNTIF Multiple Column Criteria

    Dear Forum,

    Please see excel attached.
    I need a formula to count how many products with product ID my competitor has available and I don't.

    If Column A (Product ID) is not blank, count
    If Column B (Me) cell is blank, count
    If Column C (Competitor) cell is not blank, count

    In the example attached, the result I'm looking for is 3 (products I have with ID that my competitor offers and I don't)
    Please note that on each column there will be blank and non blank cells.

    Your assistance will be greatly appreciated!!!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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