Totaling Cell to the right of like labels
Find bottlenecks in your Excel workbooks
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Totaling Cell to the right of like labels

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have a ledger where the labels in Column B change each month. There are repeat values in column B: which I would like to subtotal or SUM.

    A B C
    2/13 City Bank 5.00
    2/15 ABC pest 100.00
    2/15 contract help 50.00
    2/25 City Bank 50.00
    2/30 contract help 150.00
    3/1 ABC pest 100.00
    3/1 Gloria Indoors 200.00

    The result I want is

    City Bank 55.00
    ABC Pest 200.00
    Contract help 200.00
    Gloria Indoors 200.00


    Each month the labels might be different so I don't want to have to put in the formula what label to search for.

    [ This Message was edited by: lovit on 2002-03-13 18:13 ]

  2. #2
    Legend NateO's Avatar
    Join Date
    Feb 2002
    Location
    Minneapolis, Mn, USA
    Posts
    9,700
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    See the menu items "Data"-> "subtotals"

    Subtotal by change in value in column B.

    Cheers,

    Nate

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com