Heres one way... choose a section where you want the results.

Create a column of the days like

Mon
Tue
Wed
etc

Then in the cell next to Monday put the formula
=SUMIF($A$1:$A$3,E1,$C$1:$C$3)

Remember this is assuming that the word "Mon" is in cell E1. Make sure you
leave the $ signs in the code except for on the E1 part. Then copy this code
and paste it down throughout the days of the week. Adjust it to fit your data.

Hope this helps


"kevcar40" wrote:

Hi
I have 3 columns of data
A = day of the week
B = Fault that occurred
C = Time

ie
A B C
Mon Snapped 0:1:00
Mon Snapped 0:1:00
Tue Snapped 0:1:00

What i want to do is

Sum the time for each fault depend on the day

Result is
Mon Snapped 0:2:00
Tue Snapped 0:1:00


i was thinking of sumif or sumproduct
What is the best way of doing this please

Thanks
kevin