+ Reply to Thread
Results 1 to 2 of 2

Count column A if Coumn B = Monday ?

  1. 08-03-2007, 09:36 AM #1
    paulizaz
    paulizaz is offline
    Registered User
    Join Date
    03-22-2007
    Posts
    21

    Count column A if Coumn B = Monday ?

    How to count one column when another column equals something?

    Example Count colum B if Column A = Monday:


    A B
    SUNDAY 5
    MONDAY 3
    TUESDAY 2
    SUNDAY 5
    MONDAY 1
    TUESDAY 2

    Results should be 4.
    Reply With QuoteRegister To Reply
  2. 08-03-2007, 10:25 AM #2
    Ron Coderre
    Ron Coderre is offline
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Count column A if Coumn B = Monday ?

    Try the SUMIF function

    with
    Col_A containing the day names (Monday, etc), beginning in A1
    Col_B containing numeric values associated with the Col_A day names.

    Then
    C1: Monday
    This formula returns the sum of Col_B values where the Col_A value is Monday:

    D1: =SUMIF(A1:A100,C1,B1:B100)

    Does that help?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1