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

Some videos you may like

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
  •