+ Reply to Thread
Results 1 to 4 of 4

count number of values where corresponding cells are not blank

  1. #1
    Forum Contributor
    Join Date
    10-18-2012
    Location
    new york
    MS-Off Ver
    Excel 2013
    Posts
    152

    count number of values where corresponding cells are not blank

    i would like a formula that counts the number of values in column A where the corresponding cells in columns B and C are NOT BLANK.
    can anyone help?
    thank you

  2. #2
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: count number of values where corresponding cells are not blank

    Try this...

    =COUNTIFS(A2:A10,"<>",B2:B10,"<>",C2:C10,"<>")
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Forum Contributor
    Join Date
    10-18-2012
    Location
    new york
    MS-Off Ver
    Excel 2013
    Posts
    152

    Re: count number of values where corresponding cells are not blank

    works perfectly. thank you so much. would you be able to help me with this at all?
    http://www.excelforum.com/excel-form...html?p=3093501

  4. #4
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: count number of values where corresponding cells are not blank

    I'll take a look.

+ Reply to Thread

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