+ Reply to Thread
Results 1 to 6 of 6

SUM IF Formula issue

  1. #1
    Registered User
    Join Date
    02-11-2016
    Location
    London
    MS-Off Ver
    2010
    Posts
    21

    SUM IF Formula issue

    Hiya,

    I am trying sum revenue from a database using 3 similar keywords by month

    Travel Suit
    Suit
    A Suit To Travel in

    I am using the following formula =SUMIF($A:$C,"Travel Suit",$C:$C)+SUMIF($A:$C,8,$B:$B) but is not working
    I attached the docuement in case could be helpful what I am doing

    Would be appreciated some help on this

    Regards

    Olatz

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016 / 365
    Posts
    7,104

    Re: SUM IF Formula issue

    I assume you want a count of the number of times the word, "Suit" shows up in columns A:C?

    If so, the formula is COUNTIFS($A:$C,"*Suit*")
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Valued Forum Contributor PeteABC123's Avatar
    Join Date
    09-21-2012
    Location
    Botswana
    MS-Off Ver
    Professional Plus 2019
    Posts
    786

    Re: SUM IF Formula issue

    Thought: depending on the number of records analyzed and the capabilities of your computer, it may be in your interest to better define a range in terms of the number of rows analyzed. Having it look through over a million rows in each column may not be desirable; it could bog things down. Might use a range, such as $A$2:$C$10000 if that captures all your data to be analyzed. . .or similar.

    Pete

  4. #4
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: SUM IF Formula issue

    Quote Originally Posted by Obeitia View Post
    I attached the docuement in case could be helpful what I am doing
    Don't see an attachment.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  5. #5
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: SUM IF Formula issue


  6. #6
    Registered User
    Join Date
    02-11-2016
    Location
    London
    MS-Off Ver
    2010
    Posts
    21

    Re: SUM IF Formula issue

    hiya, thank for your answer, yeah is a duplicate thread, I clicked send thread twice

+ 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. [SOLVED] Index Match Formula Issue - Lookup Value is a Formula
    By dodgemain in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-06-2016, 11:48 AM
  2. formula issue in VBA
    By cmccabe in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-26-2014, 04:50 PM
  3. Lookup Formula Issue, Search issue
    By kperitz in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 04-07-2014, 01:50 PM
  4. Formula Issue
    By reliv4mary in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-27-2013, 02:16 PM
  5. Excel 2007 : If then formula issue
    By bjohnsonac in forum Excel General
    Replies: 1
    Last Post: 04-09-2009, 12:56 PM
  6. formula issue
    By AlienBeans in forum Excel General
    Replies: 7
    Last Post: 05-29-2006, 11:55 PM
  7. An issue regarding the formula
    By HuaMin in forum Excel General
    Replies: 2
    Last Post: 12-07-2005, 11:45 AM

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