+ Reply to Thread
Results 1 to 3 of 3

Thread: find out and sum ...

  1. 07-04-2008, 01:33 AM #1
    ncd10482
    ncd10482 is offline
    Registered User
    Join Date
    07-04-2008
    Location
    GAZA
    Posts
    5

    find out and sum ...

    please , some help ...

    i have 2 columns one for NAMES , and another for PAYMENTS

    i want to sum the all payments for a specific name ,

    for example :

    NAME PAYMENTS
    A 344
    B 54
    C 432
    B 34
    B 167
    C 348
    A 32
    C 642

    i want to sum all payments of B

    thanks
    Last edited by ncd10482; 07-04-2008 at 01:37 AM.
    Reply With Quote Reply With Quote
  2. 07-04-2008, 02:11 AM #2
    ratcat
    ratcat is offline
    Valued Forum Contributor ratcat's Avatar
    Join Date
    03-07-2008
    Location
    Rural NSW, Australia
    MS-Off Ver
    Vista 2007
    Posts
    815
    G'day and welcome to the forum,


    To your posted example use the sumif

    eg

    
=SUMIF($A$1:$A$1000,"B",$B$1:$B$100)
    Hope that helps
    Last edited by ratcat; 07-04-2008 at 02:13 AM.
    Have I made you happy ??? If yes, please make me happy by pressing the Reputation icon in my post.
    Please don't forget to do the same to other contributors of this forum.

    Thanks


    I don't void confusion, I create it
    Reply With Quote Reply With Quote
  3. 07-04-2008, 04:02 AM #3
    ncd10482
    ncd10482 is offline
    Registered User
    Join Date
    07-04-2008
    Location
    GAZA
    Posts
    5
    Quote Originally Posted by ratcat
    G'day and welcome to the forum,


    To your posted example use the sumif

    eg

    
=SUMIF($A$1:$A$1000,"B",$B$1:$B$100)
    Hope that helps


    thanks bro so much

    it works 100%

    you are a great one , thanks again
    Reply With Quote Reply With Quote
+ 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.2.0