+ Reply to Thread
Results 1 to 3 of 3

Excel counting with multiple criteria

  1. #1
    Registered User
    Join Date
    07-05-2012
    Location
    London,England
    MS-Off Ver
    Excel 2007
    Posts
    1

    Excel counting with multiple criteria

    I want excel to count the number of times a "0" is displayed in columns A & B, but not when a BLANK is there. I also only want it to count this for a further selection of criteria.

    Example:

    ItemNumber ColumnA Column B

    1 0 0
    1 0
    1
    2
    2 0 0
    2

    What I would want from this is to spreadsheet to count how many times ColumnA & Column B are both "0", for item 1, and to count how many times item 2 has "0" in column A and B on a seperate sheet of the spreadsheet.

    Any help much appreciated.

    Dan

  2. #2
    Forum Expert NBVC's Avatar
    Join Date
    12-06-2006
    Location
    Mississauga, CANADA
    MS-Off Ver
    2003:2010
    Posts
    34,902

    Re: Excel counting with multiple criteria

    =COUNTIFS('Sheet1'!A:A,1,'Sheet1'!B:B,0,'Sheet1'!C:C,0)

    where Sheet1, column A:C contain the data...

    This checks that column A contains a 1, while B and C contain 0
    Where there is a will there are many ways.

    If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner

    Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.

  3. #3
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Excel counting with multiple criteria

    Hi Dan,

    Welcome to the forum.

    See the attached file where I have used countifs function to achieve the desired results.. thanks.

    Counting.xlsx

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey
    +91 9810929744
    dilipandey@gmail.com

+ 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