Results 1 to 4 of 4

Thread: How to summarize info with formulas?

  1. #1
    Board Regular
    Join Date
    Mar 2017
    Posts
    62
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default How to summarize info with formulas?

    Hi,

    Can someone please help me with this?

    I have 5 column of raw data like this: Employee, Month, Day, Type of task, Hours

    Without using pivot tables, I would like to summarize the information in a table like this:

    Dec-18 Jan-19 Feb-19 Total quater
    Days Days Days
    Employee 1
    Task a x x x x
    Task b x x x x

    Thanks!

    Edu

  2. #2
    Board Regular
    Join Date
    Apr 2010
    Posts
    10,985
    Post Thanks / Like
    Mentioned
    13 Post(s)
    Tagged
    1 Thread(s)

    Default Re: How to summarize info with formulas?

    I have 5 column of raw data like this: Employee, Month, Day, Type of task, Hours
    Without using pivot tables, I would like to summarize the information in a table like this:
    Dec-18 Jan-19 Feb-19 Total quater
    Days Days Days
    Employee 1
    Task a x x x x
    Task b x x x x
    EMPLOYEE MONTH DAY TYPETASK HOURS
    1 01/01/2018 Mon a 1500
    HOW DO WE KNOW HOW LONG THE TASK IS - could hours be eg 1500

  3. #3
    Board Regular
    Join Date
    Mar 2017
    Posts
    62
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to summarize info with formulas?

    Sorry, x = number of hours

  4. #4
    Board Regular
    Join Date
    Apr 2010
    Posts
    10,985
    Post Thanks / Like
    Mentioned
    13 Post(s)
    Tagged
    1 Thread(s)

    Default Re: How to summarize info with formulas?

    Employee, Month, Day, Type of task, Hours
    emp month day tasktype hours
    fred jan 2 a 8 jan feb mar
    tom jan 2 b 7 fred a 16 0 0
    alan jan 2 a 9 fred b 17 0 0
    fred jan 3 b 8 tom a 7 0 0
    tom jan 3 a 7 tom b 14 0 0
    alan jan 3 b 9 alan a 18 0 0
    fred jan 4 a 8 alan b 9 0 0
    tom jan 4 b 7
    alan jan 4 a 9
    fred jan 5 b 9
    fred's 16 for task a derived by
    =SUMPRODUCT(($A$5:$A$14=$I6)*($B$5:$B$14=K$5)*($D$5:$D$14=$J6)*($E$5:$E$14))

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
  •