How to summarize this information?

[EduPAz]

Hi,

I have in the master file (worksheet1) this information:

PROJECT (Col. A):
1
2
3
1
2
3

TASK (Col. B):
01-training
02-inventory
03-sample reception
02-inventory
03-sample reception
03-sample reception

HOURS (Col. C)
10
25
33
47
100
150

Is there a way to present the information using this format? The idea is to do it by formula instead of pivot tables.

PROJECT (Col. A)

01-TRAINING
Total Hours (Col. B)
Counts (Col. C)
Mean (Col. D)

02-Inventory
Total Hours (Col. E)
Counts (Col. F)
Mean (Col. G)

03-Sample reception
Total Hours (Col. H)
Counts (Col. I)
Mean (Col. J)

Thanks!

Edu

 

[Special-K99]

Is this a one-off thing or will you want to repeat this process occasionally ?

What's Counts ? A count of what? The occurrences of Hours ? So 01-Training would be 1 since theres only one occurrence of 01-Trianing Hours ?
But Inventory would be 2 and Sample Reception would be 3 ?

 

[Special-K99]

I dont really have time to solve this but answering the above questions may help others who may want to try.

 

[EduPAz]

Hi,

Counts= For each project, the occurrence of each task.
For example, For project 2, the occurrence of task 03-sample reception is 1 (counts=1)