Doug

An array formula should do this.

=sum(if((G6:G12=100)*(J6:J12="here"),I6:I12,false) )

Type in the formula and press CTRL+SHIFT+ENTER to enter it.

Watch out for the relative/absoulte references if you intend to move
this around elsewhere.

More info on arrays at Chip Pearsons site
http://www.cpearson.com/excel/array.htm

Good luck

Murray


Doug wrote:
I have been able to partialy add the sums for the following table using sum(if

1/9/07
g h i j
k l
desc. ser. code date rec. cost/day status cost to date
date ret.
xxx xxx 100 1/1/07 $100 here $200
xxx xxx 200 1/1/07 $100 here $200

xxx xxx 100 1/1/07 $100 return $200
1/5/07
xxx xxx 300 1/1/07 $100 here $200

xxx xxx 100 1/1/07 $100 enroute $200


What I am attempting to do is add all cells for a daily cost where the
equipt. with the same cost code is either still here or enroute, and make it
quit adding up items on a daily ticket for parts returned. the formula I am
using is

=SUM(IF((G6:G12="100")+(J6:J12="here"),I6:I12))

The problem is that it adds the items here even though it is the incorrect
cost code. Any help is greatly appreciated as I take this info and add to a
second worksheet w/ the indivdual cost / per day of each code broke down.