Results 1 to 4 of 4

Calculating sum of relative cells

Threaded View

  1. #1
    Registered User
    Join Date
    02-11-2009
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2003
    Posts
    15

    Calculating sum of relative cells

    Hey guys. Feel like i'm spamming the forum a bit but the more I work with Excel the more I realize that I'm not that good at it Anyways, I'm in need of a quite advanced formula (for me) that sums up relative relative rows of a specified column. The rows relation depends on the ID-number of the person. Look at my attachment.

    In Sheet1 I have an extract of the data I'm working with. It's a medical record of different people in a study. The ID (col. B) seperate the different people. One person can have several perscriptions (spelling?) of medicine. Every perscription has an "fddd", a daily dose (col. L). I want to add up all the daily doses for every seperate ID of my data in Sheet2. So for example, for ID1 I want it to sum L3:L6 in Sheet1 and return it to Sheet2!B2. If the ID is not found I want it to be blank. Cheers
    Attached Files Attached Files
    Last edited by nxc; 02-19-2009 at 09:55 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