+ Reply to Thread
Results 1 to 3 of 3

caluclate total time for those that were present

  1. #1
    Registered User
    Join Date
    09-11-2006
    Posts
    8

    caluclate total time for those that were present

    I would like to add the total minutes spent by each person and output the sum to column E.
    \1

    For example, if “jerr” was present for BossFight’s 1, 2, and 3 then I want to add the given values for those Bossfight’s to jerr and get his total.

    If there is TEXT in column B4, add value in B2
    If there is TEXT in column C4, add value in C2
    If there is TEXT in column D4, add value in D2
    Output sum to E4

    So “jerr” would equal 20
    “sab” = 14
    “pete” = 10

    How would I go about doing this?

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Hi,

    This might work

    =SUMPRODUCT(--(B4:D4="Jerr")*(--($B$2:$D$2)))
    =SUMPRODUCT(--(B5:D5="Sab")*(--($B$2:$D$2)))
    =SUMPRODUCT(--(B9:D9="Pete")*(--($B$2:$D$2)))

    etc.

    The minute cells $B$2:$D$2 need to adding with the Dollar sign.

    The Name can be replace with a cell ref e.g if B4 always has a name the formula could look like

    =SUMPRODUCT(--(B4:D4=B4)*(--($B$2:$D$2))) etc

    VBA Noob

  3. #3
    Registered User
    Join Date
    09-11-2006
    Posts
    8
    that did the trick. thank you kindly
    Last edited by SabinN; 09-17-2006 at 06:48 PM.

+ 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