# Thread: How to summarize info with formulas? Thanks:  1 Post #5208566 (1) Likes:  1 Post #5208566 (1)

1. ## How to summarize info with formulas?

Hi,

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. ## 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. ## Re: How to summarize info with formulas?

Sorry, x = number of hours

4. ## 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))