Results 1 to 6 of 6

Adding data from specific names ugh!!

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-17-2008
    Location
    Vernon, CT
    Posts
    132

    Question Adding data from specific names ugh!!

    I have a sheet that has the same employee names several times in different orders in the same column with data to the right of it.Example

    Name.......Pieces...hrs
    .....A........B........C
    (1)John...1000......12
    (2).........2000......20
    (3)Jay.....2000......31
    (4).........2500.....20
    (5)John...2000.....50
    (6).........5000.....60
    (7)Bill......1200.....40
    (8)..........3000.....60

    I need the peices and hours total for each name on another sheet.

    So I would have John on my sheet and would need to to grab and add the info from B2 & B6 into one cell (since it is the same person). I can always drag the info over for hours once I find a way to do this for the pieces I would think. The problem is that I don't want to add in B1 & B2 for John because those numbers are not a part of the total.

    So is there a way or formula for one cell to look at the entire sheet and everytime it sees the name john to add the information one column over and one cell down and then give a total?

    I may be able to do some formatting and have all the info I need directly to the right. So I would have (A1) John, (B1) Data, (C1) Data. The issue would be a cell finding the name, taking the information directly to the right of it and adding it as many times as the name is found on the sheet.

    I appreciate the help.

    Jay
    Last edited by jayclinton; 12-17-2008 at 11:50 PM.

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1