+ Reply to Thread
Results 1 to 3 of 3

Sum column AB by date range in Column N and text in column X

  1. #1
    Registered User
    Join Date
    11-13-2012
    Location
    New Jersey, USA
    MS-Off Ver
    Excel 2010
    Posts
    29

    Sum column AB by date range in Column N and text in column X

    Hey Guys,

    I was looking for help that I think may be quicker to ask then try to go back and figure it out for a few hours.

    I have two worksheets. Sheet 1 is named = Summary
    Sheet 2 is named = RawData_cYTD_2014

    On Summary Sheet in Cell b4 this is what I am attempting to sum all from the RawData_cYTD_2014.

    I want to (sum column AB) only if (Column N is between 1/01/2014 and 1/31/2014) and (Column X contains the text apple).

    thanks so much

    -richtree

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,606

    Re: Sum column AB by date range in Column N and text in column X

    Use sumifs
    as dates are couuntry sensitive I'd do this like:
    Please Login or Register  to view this content.
    Best Regards,

    Kaper

  3. #3
    Forum Expert bebo021999's Avatar
    Join Date
    07-22-2011
    Location
    Vietnam
    MS-Off Ver
    Excel 2016
    Posts
    9,409

    Re: Sum column AB by date range in Column N and text in column X

    Have you tried SUMIFS?
    =SUMIFS(RawData_cYTD_2014!AB1:AB100,RawData_cYTD_2014!N1:N100,">="&DATE(2014,1,1),RawData_cYTD_2014!N1:N100,"<="&DATE(2014,1,31),RawData_cYTD_2014!X1:X100,"Apple")
    Quang PT

+ 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. Find most recent date in Column Headings in a Range, insert new column and heading
    By mikey3580 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-07-2014, 08:28 AM
  2. [SOLVED] Cond. formatting a column/Range, highlight cell in column/range if equal to specific text
    By DFrank231 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-19-2013, 03:35 PM
  3. Formula to Check Column A for date range and count Column B
    By realniceguy5000 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-28-2009, 12:58 PM
  4. If text mathces column 1 range, display value in column 2 cell
    By brillison in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-03-2008, 03:59 PM
  5. COUNTIF: 2 criteria: Date Range Column & Text Column
    By MAC in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 02-03-2006, 05:10 PM

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