+ Reply to Thread
Results 1 to 2 of 2

Attempting to combine a sumifs for specific text and date

  1. #1
    Registered User
    Join Date
    07-25-2019
    Location
    New York
    MS-Off Ver
    2016
    Posts
    12

    Attempting to combine a sumifs for specific text and date

    Hello,

    I am attempting to combine a sumif for a specific date (IE summing by month and another for year of the current date) and if a cell contains specific text. IE cats vs dogs where cat will be labeled as tiger and lion in the same cell. Tiger - cat, Lion - cat.

    The end goal is being able to sum the total number of animals by cat or dog per month then year.

    Thanks!

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    2012 for Mac at home
    Posts
    7,305

    Re: Attempting to combine a sumifs for specific text and date

    that is a bit of a vague description, perhaps you could upload a sample workbook representing what you have AND expected results so we can structure a formula for you.
    to upload a file click go advanced under the quick reply box, then midway down click on the blue hyper link "manage attachments" then go to browse then upload and close window then submit reply to upload.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

+ 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. validate text & combine specific cells
    By shiva_raj in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-09-2017, 02:39 PM
  2. SUMIFS name column matches, along with a specific date range
    By mhewitson15 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-20-2016, 05:00 AM
  3. [SOLVED] Attempting to combine two lists
    By mrvp in forum Excel General
    Replies: 12
    Last Post: 09-27-2014, 07:24 PM
  4. Help: Adding Revenue by Date-specific Cohorts Using SUMIFS
    By roguenate in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-17-2014, 02:47 PM
  5. SUMIFS formula that includes specific text
    By aurisab in forum Excel General
    Replies: 15
    Last Post: 12-16-2012, 08:20 PM
  6. Replies: 2
    Last Post: 11-12-2012, 02:49 PM
  7. SUMIFS with specific text as criteria
    By Bjordion in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-05-2011, 04:26 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