+ Reply to Thread
Results 1 to 3 of 3

Compare/Sum different Collums

  1. 09-12-2007, 12:03 PM #1
    Jimbras
    Jimbras is offline
    Registered User
    Join Date
    09-12-2007
    Posts
    9

    Compare/Sum different Collums

    Hey folks,

    I have a question (an easy one i guess...)

    Please consider the following example:

    Car Engine Color
    Fiat - Blue
    Peugeot - Yellow
    Fiat - Blue
    Fiat - Yellow
    Ferrari - Red


    I am looking for a function that provide me the result of all the "Fiat" that are "Blue".

    Couldnt find any.

    Your help is welcomed!
    Reply With QuoteRegister To Reply
  2. 09-12-2007, 12:05 PM #2
    nattasiray
    nattasiray is offline
    Registered User
    Join Date
    06-11-2007
    Location
    Nonthaburee Province, Thailand
    MS-Off Ver
    MS Office 2003 to MS Office 2010
    Posts
    82
    =SUMPRODUCT(Car="Fiat")*(Color="Blue"))

    Will Return the number of Car = Fiat that body is blue
    N. Yauvasuta
    Power User Excel.
    Reply With QuoteRegister To Reply
  3. 09-12-2007, 12:11 PM #3
    Jimbras
    Jimbras is offline
    Registered User
    Join Date
    09-12-2007
    Posts
    9
    Quote Originally Posted by nattasiray
    =SUMPRODUCT(Car="Fiat")*(Color="Blue"))

    Will Return the number of Car = Fiat that body is blue
    It Works...

    God Damm...maybe its time for me to "Decently" learn how to use Excell...

    Tks.
    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