If function required??

[iazcac]

Hi

I have a spreadsheet where people enter the time they have spent on a project. A number of rows can be added for each project

What I want to do is calculate the total time in Column C (Total Time) and display it on each row


Project......... TimeSpent....... Total Time
Project A............5......................8
Project A............3...................... 8
Project B............2.....................3
Project B............1......................3


Do I need an IF formula to do this? Tried lots of combinations but not having any luck, and pretty sure it is possible!

Thanks
C

 

[T. Valko]

Hi

I have a spreadsheet where people enter the time they have spent on a project. A number of rows can be added for each project

What I want to do is calculate the total time in Column C (Total Time) and display it on each row


Project......... TimeSpent....... Total Time
Project A............5......................8
Project A............3...................... 8
Project B............2.....................3
Project B............1......................3


Do I need an IF formula to do this? Tried lots of combinations but not having any luck, and pretty sure it is possible!

Thanks
C

Try this...

Enterd in C2 and copied down:

=SUMIF(A$2:A$5,A2,B$2:B$5)

 

[iazcac]

Worked a treat. Thanks