Results 1 to 4 of 4

making simple calculations from a long list with repeating values

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-22-2009
    Location
    Sheffield, England
    MS-Off Ver
    Excel 365
    Posts
    143

    making simple calculations from a long list with repeating values

    Hello.

    I have 4 lists of illness conditions, each with a number next to them which represents the number of days lost to sickness in that year.

    I.e.,
    Back injury -234
    Head injury - 111

    etc etc

    The problem is not all the conditions are on each list so I cant just copy and paste the lists next to each other.

    I have put all the conditions into one list and sorted them alphabetically so I can now see which conditions appear more than once.

    Is there a way to add up the totals of days lost due to each condition (possible of 4 values for each condition), without having to do it manually?

    hope this makes sense??

    many thanks
    Attached Files Attached Files
    Last edited by burnsie; 03-23-2011 at 06:28 AM.

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