+ Reply to Thread
Results 1 to 7 of 7

Struggling. sum of number of rows which meet criteria across columns

  1. #1
    Registered User
    Join Date
    10-21-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    3

    Struggling. sum of number of rows which meet criteria across columns

    Hi,

    I'm struggling with what I think is a pretty simple formula.

    I have a table with data in it. Each row has information in some/all of the cells.

    On a summary sheet I need to add up the number of rows on the table which meet a set of criteria across multiple columnes.

    For example, Column A= Open, Column B= Approved, and Column C= Blank/deferred - this should = 1 on my summary sheet.

    Another way to look at it may be, if Column A= Open, and anything in column B or C= Approved, then this should count as 1.

    Any help would be much appreciated!

    Thanks,

    T

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: Struggling. sum of number of rows which meet criteria across columns

    Hello T and welcome to the forums.

    Are you able to attach a sample spreadsheet with a before and after example?

  3. #3
    Registered User
    Join Date
    10-21-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Struggling. sum of number of rows which meet criteria across columns

    Hopefully this will help. It's an image though unfortunately as I'm restricted from loading up direct from excel.

    Picture1.jpg

  4. #4
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Struggling. sum of number of rows which meet criteria across columns

    Give a try to COUNTIF & COUNTIFS functions.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  5. #5
    Registered User
    Join Date
    10-21-2013
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Struggling. sum of number of rows which meet criteria across columns

    Oh.. I have! But I'm struggling with what the formula should be. Mental block.

  6. #6
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Struggling. sum of number of rows which meet criteria across columns

    I am sorry but i don't have the time to create a sample worksheet. If i had a sample worksheet i would be happy to show you how to do this.

  7. #7
    Registered User
    Join Date
    05-29-2005
    MS-Off Ver
    2013
    Posts
    36

    Re: Struggling. sum of number of rows which meet criteria across columns

    Quote Originally Posted by tyseley View Post
    Oh.. I have! But I'm struggling with what the formula should be. Mental block.
    Have a look at the attached sheet...
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Trying to countif 2 columns meet different criteria
    By ediancoc in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-07-2013, 03:37 PM
  2. VBA- deleting rows which contain cells that meet criteria, but skip alpha rows
    By cheapkid1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-30-2012, 08:49 AM
  3. Replies: 2
    Last Post: 06-15-2011, 04:33 PM
  4. SumIf two columns meet criteria
    By adam2308 in forum Excel General
    Replies: 3
    Last Post: 11-22-2009, 10:32 AM
  5. count rows that meet two criteria in two different columns?
    By dsk3808 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-28-2006, 04:20 PM

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