+ Reply to Thread
Results 1 to 3 of 3

How to sum 1 column I have a two-column array, where column 1 is a list of names and

  1. #1
    Registered User
    Join Date
    11-19-2011
    Location
    Bristol
    MS-Off Ver
    Excel 2007
    Posts
    4

    How to sum 1 column I have a two-column array, where column 1 is a list of names and

    I have a two-column array, where column 1 is a list of names and column 2 is times. How can I sum the times in column 2 with the same name in column 1?

    This is an example of the data and I want to sum the times in column 2 that correspond to the name in column 1. eg. the total time grazing would be 01:15, the total time resting would be 03:13.
    resting 03:06
    walking 00:32
    grazing 00:12
    resting 00:07
    grazing 01:03

    I'm sure there must be a formula which would allow me to calculate this rather than doing it manually which will take a long time as there are a lot of data.

    Thanks for your help.

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    14,739

    Re: How to sum 1 column I have a two-column array, where column 1 is a list of names

    Try SUMIF, e.g.

    =SUMIF(A:A,"Grazing",B:B)
    Audere est facere

  3. #3
    Registered User
    Join Date
    11-19-2011
    Location
    Bristol
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: How to sum 1 column I have a two-column array, where column 1 is a list of names

    I knew I was being stupid not sorting that out.

    Thank you

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1