Use SUMIF

Formula you need to write into cell B1 in Overview is
=SUMIF(Data!A:A,A1,Data!C:C)

then copy this down however far you need it

http://www.excel-ant.co.uk 'under construction




Alain R. wrote:
Hi,

I have a workbook excel in which i have 2 sheets "overview" and "data".
"Overview" should display some results calculated from "data" sheet.
in "data" sheet i have a list of tasks done included time needed.

I want to sum all times spent (available on "data") to 1 task and to
display this result in "overview".

e.g :

Overview sheet :

Col A Col B
Planning
Analysis "myformula"
Development
Testing
...


Data sheet :

Col C Col E
Planning 00:12:00
Planning 01:34:21
Analysis 01:45:00
Planning 00:17:36
Analysis 20:40:00
...

in this case, "myformula" should return me : 01:45:00 + 20:40:00, so
22:25:00 as time spent on this task.

How can i do that (because i must scan all records) ?

thanks a lot,
Alain