+ Reply to Thread
Results 1 to 3 of 3

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 BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,945

    Re: SUM IF Formula issue

    You appear to have forgotten the attachment.
    Would make it much easier to help if we could see that.

    BSB

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: SUM IF Formula issue

    Quote Originally Posted by Obeitia View Post
    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
    Looks like you forgot the attachment?

    Not sure what the "8" is for, but maybe...
    =SUMIF($A:$C,"*Suit*",$C:$C)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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