Tracking the time of testimony with Excel

Tonight's tip shows how you can use a simple SUMIF formula in Excel to automatically track how much time each party has used during a trial.

As shown in this example, the SUMIF formula first references a range in which the parties names are listed (in this example in column C) with an absolute reference . The party's name is listed to the left of the formula in cell B12. The last part of the SUMIF formula is a column listing the amount of time between the beginning and end of one side's questioning. The formula only adds up the values in column G which have the value in B12 in column C.

=SUMIF($C$2:$C$9,B12,$G$2:$G$9)