A lookup with a SUM function?
Results 1 to 2 of 2

Thread: A lookup with a SUM function?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Dec 2006
    Posts
    256
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default A lookup with a SUM function?

    Hi all.
    A col has Dates in them this sheet is called "Log"

    Col A Col B Col C
    Wed, 19 Jun 19 5:30 6:40
    Fri, 21 Jun 19 1:49 1:23
    Fri, 21 Jun 19 1:11
    Fri, 21 Jun 19 1:33 3:12



    I have another sheet that has dates for JUNE sheet name "Monthly".
    On the row that has Date on the Monthly sheet I would like it to insert and merge the same date on different rows totaling them.

    A20 on Monthly Sheet has the date of "Wed, 19 Jun 19" I want it to grab the col b from the Log sheet and insert inCol B onto col B on the Log sheet on same row that Wed 19 june is on.

    Then A22 on Monthly sheet has the date of 21 June I want that row and col be to total all in COL b on log sheet and insert '4:33" in B22 on.

    I wish I could do a screen shot an show it more clearly but I know someone might understand my weak explanation.
    Cheers

  2. #2
    Board Regular shift-del's Avatar
    Join Date
    Aug 2009
    Location
    Former industrial area
    Posts
    506
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: A lookup with a SUM function?

    Hi

    Try this:
    Code:
    =SUMIFS(Log!$B$1:$B$4,Log!$A$1:$A$4,A20)
    Be Seeing You!
    ... shift-del
    {Office 365 since Nov 2014}

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •