# How to summarize info with formulas?

#### EduPAz

##### Board Regular
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

<tbody>
</tbody>

Thanks!

Edu

#### oldbrewer

##### Board Regular
 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

<colgroup><col span="4"><col><col span="2"><col><col span="3"></colgroup><tbody>
</tbody>

#### EduPAz

##### Board Regular
Sorry, x = number of hours

#### oldbrewer

##### Board Regular
 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))

<colgroup><col span="18"></colgroup><tbody>
</tbody>

1,078,491
Messages
5,340,683
Members
399,389
Latest member
JayNExcel

### This Week's Hot Topics

• Problem with Radio Button's format control
I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
• Last Display on userform to a Listbox
[CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
• Rename and move files to a new location
Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
• Help with True/False Formula
Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
• Clear extra characters from a provided range of cells
Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
• Help with Current and highest streaks
Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...