Grupe and sum in tabel

[Silentspeed]

Sorry my bad english

I have a table with column - A, B, C, D,
In A I have 9494 rows with 200 differetnt tekst
In B I have 9494 rows only 2 different tekst
In C I have 9494 rows with time, in format 00:00
In D i want to have formula that group sum of C when text in colum A is the same.

Example:

A B C
TEST1 OFF 00:30
TEST1 ON 01:00
TEST1 ON 01:00
TEST1 ON 01:00
TEST2 OFF 00:50
TEST2 ON 02:00
TEST2 OFF 02:00
TEST2 OFF 03:00
TEST3 ON 01:00
TEST3 OFF 01:00
TEST4 ON 02:00
TEST4 ON 02:00

Result need to be, if the are same tekst in A, and there is ON in B, then in D sum all ON where is same text in A
Example

A B C D
TEST1 OFF 00:30 03:00
TEST1 ON 01:00
TEST1 ON 01:00
TEST1 ON 01:00
TEST2 OFF 00:50 02:00
TEST2 ON 02:00
TEST2 OFF 02:00
TEST2 OFF 03:00
TEST3 ON 01:00 01:00
TEST3 OFF 01:00
TEST4 ON 02:00 04:00
TEST4 ON 02:00

i cant use group bicause the are to much differet text in A, i have try sumprodukt, that work but only one test
hope someone can help me

[zbor]

Can you upload example workbook?

[Silentspeed]

zbor neznam kako :-)

[alansidman]

In your response window, click on the Go Advanced tab at the bottom of the window. Follow the instructions for Manage Attachments. Make sure to run a compact and repair before you upload and dummy up all confidential information.

Is this an Excel or Access Issue as you have posted in the Access Forum

[Silentspeed]

EXAMPLE 1.xlsx

ok i try

[Silentspeed]

And yes its a excel issue

[zbor]

Look at the example:

(I've just conferted table to the range)

[Silentspeed]

TNX, that was good, but I get easy way to change table to pivottable and that work perfekt