I'd use a pivot table or else SUMPRODUCT.

For info on pivot tables see he http://contextures.com/tiptech.html
(scroll to the P section)

See here for info on SUMPRODUCT:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Dave

--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"kevcar40" wrote:

i have the following formula

Column CA holds the Operation name
Column CB holds the Actual Fault
Column CC holds the time for each occurance

the same fault can occur on different operations

What i want to do is sum the time value for each fault by each
operation

thanks

kevin